Re: Serial - last value

hendra kusuma wrote:
>
> Let me get this clear
> it should looks like this?
>
> create function something() returns integer as $$
> declare
>   ret integer;
> begin
>   -- just assume something table has a serial column as primary key
>   insert into something values ('a value');
>   select currval('something_sequence') into ret;
>   return ret;
> end
>
> $$ language 'plpgsql';

That should work fine, although for that particular case with recent
versions you could just use:

INSERT INTO some_table (id, mytext) VALUES (DEFAULT, 'a value')
RETURNING id;

--
  Richard Huxton
  Archonet Ltd