From: "Bruce Momjian" <[EMAIL PROTECTED]>
> MY book in chapter 18 has a Pl/PgSQL function called change_statename
> that does insert/update automatically.
>
> http://www.postgresql.org/docs/awbook.html
The functions called get_details though, so I assumed it's supposed to be
shorthand for a joi
27, 2001 3:52 PM
> > To: Jeff Eckermann
> > Cc: [EMAIL PROTECTED]; wade
> > Subject: Re: [SQL] RE: pl/pgsql and returning rows
> >
> > MY book in chapter 18 has a Pl/PgSQL function called change_statename
> > that does insert/update automatically.
> >
MY book in chapter 18 has a Pl/PgSQL function called change_statename
that does insert/update automatically.
http://www.postgresql.org/docs/awbook.html
> As a workaround, you can insert your row into an existing table, then
> retrieve it from there later. I think you need to enumerate a
As a workaround, you can insert your row into an existing table, then
retrieve it from there later. I think you need to enumerate all of the
fields, as in 'INSERT INTO table VALUES (ret.field1,
ret.field2,...ret.fieldn);'. At least, I haven't succeeded any other way.
Messy, but the best method a
