Christopher Kings-Lynne wrote:
> You cannot add a serial column after table creation time in PostgreSQL.
But you can do the following from the query editor:
ALTER TABLE table ADD column INTEGER;
CREATE SEQUENCE table_column_seq;
ALTER TABLE table ALTER column SET DEFAULT nextval('"table_column_se
Andreas Pflug wrote:
> Ian Freislich wrote:
>
> >I can't find the pseudo-type RECORD in the drop-down list of return
> >types so it is impossible to create functions like "CREATE OR REPLACE
> >FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the
Hi
I don't know if anyone has encountered this problem before. I
couldn't find any reference to this on the list archives or FAQ.
I can't find the pseudo-type RECORD in the drop-down list of return
types so it is impossible to create functions like "CREATE OR REPLACE
FUNCTION foo (TEXT) RETURNS