hellp me on this query please

select first(name) from student;
this one work on access but i dont know how to convert to postgresql.

i want to get the first row in table student.

you guy know some function in postgresql to substitution for function first() in access.

help me please.

kevin

select name from student limit 1;

Not 100% sure about PostGreSQL, but this will work in mysql... give it a shot.

Dave

you guy know how to create a function first()
in posgresql,
can you help me out,

this function does is get the fisrt record in table
example:
we have table student

name ssn

tony 123
jonh 256

then if we select first(name) from student;

then give us :

tony

but in postgresql they dont implement this function yet, so i have to implement it ,but i dont know how ..

can you help me if you guy can,

i think i do like this but dont work right,

create function first(text)
returns text
as 'declare ret text;
begin
return $1;
end;'
language 'plpgsql';

but this is dont do what i want..

if any guy know it please help me implement this function .

thank.