change this query from access to postgre

tiger_cs

SELECT FORMAT(time),'hh:mm:ss') FROM temp;

how can you convert this(access query) in postgres query

thank

kparker

select to_char( time, "HH:MM:SS") from temp;

or perhaps the hour part should be HH24 if you want 24-hour time.

Much more detail is available at:

  http://www.postgresql.org/idocs/index.php?functions-formatting.html

Note these guys are using php!

tiger_cs

SELECT format(Avg(TimeDiff),'hh:mm:ss') FROM (SELECT Min(a.theTime)-Min(p.theTime) AS TimeDiff FROM points AS p, actions AS a);

this query is work in access database but i convert like this in postgresql but
do not work, any one help me

SELECT to_char(Avg(TimeDiff),'hh:mm:ss') FROM (SELECT Min(a.theTime)-Min(p.theTime) AS TimeDiff FROM points AS p, actions AS a);

i think that , i dont know how to use function Avg in query ,

thank..

kparker

I'm bugged by something else in your query:

   FROM points AS p, actions AS a // note: no WHERE or join

Do you really mean you want the product of points x actions?

tiger_cs

points an actions is 2 table in database
how can you solve this problem

thank

tiger_cs

how can i write this query in postgresql

select First(temp)from student;

how can you write this in postgresql

i want to get the first record in table student.
thank you guy.

kparker

i want to get the first record in table student.

Since sql is inherently unordered, you first have do determine what you mean by 'first' record, and that has to be based on the data itself, not the order in which you might have added the rows to the table.

Anon

first record mean is first row in table

that why i use
select first(name) from student;

this work in access but not apply in
postgresql
because in postgresql dont have function
first(),
i want to get first row in table student, postgresql database.

example:

table student like this
name ssn
tommy 226-35-6938
sonny 236-23-2589

then i do in access :
select first(name) from student ;
then give me, name is tommy

now i want to do like this in postgresql.

thank.

kparker

I repeat, there is no inherent first row in a genuine sql database, if by first you mean "in order of storage". Fully half the point of sql is to isolate (and insulate) you from that low-level stuff. Now, if by first you mean "lowest-numbered ssn", then sure, you can use the standard sql aggregate function min(). Same with name, or any other column.

Anon

some one help me in this query , this one not work in postresql.

select to_char(avg(time),'hh:mm:ss') from product;

this message say, can not avg(timestamp).
but i dont know how to fix it.

some one help me please.