Postgres Pro
Downloads
Home   >   mailing lists

maintain number in variable - Mailing list pgsql-sql

From Andrey
Subject maintain number in variable
Date
Msg-id 004201bfe51a$91903240$0101010a@x206
Whole thread Raw
List pgsql-sql
Tree view
Can I maintain id in variable such as:

CREATE FUNCTION function1() RETURNS int4
AS '
   $var = select nextval(''shipment_gen'');
   select $var;
'
LANGUAGE 'sql'

 

Andrey

pgsql-sql by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Need Help With Dates.
Next
From: "Mitch Vincent"
Date:
Subject: Re: case insensitive search