"Lim Berger" <[EMAIL PROTECTED]> writes:
> create table test (id serial primary key, nowd timestamp without time
> zone, processed_id varchar(10));
> create or replace rule test_ins as on insert to test
> DO UPDATE test
> SET processed_id = MYFUNCTION(NEW.id)
> WHERE id = NEW.id
> ;
I thin
Hello,
On Tue, 2004-09-28 at 13:57, Tim Penhey wrote:
> Matthew Metnetsky wrote:
>
> >So, does anyone know of (or have) good examples of queries within
> >functions (and returning sets of data)?
> >
> >Thanks in advance,
> >
> >~ Matthew
> >
> >
> Hi Matthew,
>
> I wrote up an example which ca
Matthew Metnetsky <[EMAIL PROTECTED]> writes:
> On Tue, 2004-09-28 at 10:55, Katsaros Kwn/nos wrote:
>> > So, does anyone know of (or have) good examples of queries within
>> > functions (and returning sets of data)?
>>
>> I'm not very experienced in PostgreSQL but maybe SPI functions is what you
On Tue, 2004-09-28 at 10:55, Katsaros Kwn/nos wrote:
> > So, does anyone know of (or have) good examples of queries within
> > functions (and returning sets of data)?
>
> I'm not very experienced in PostgreSQL but maybe SPI functions is what you
> need.
Yeah I took a look at them, but I'm not sol
> So, does anyone know of (or have) good examples of queries within
> functions (and returning sets of data)?
I'm not very experienced in PostgreSQL but maybe SPI functions is what you
need.
Regards,
Ntinos Katsaros
---(end of broadcast)---
TIP 5:
