Re: [SQL] pl/pgsql Limits

2001-01-24 Thread Josh Berkus
Ian, > That works, but when do you delete the records? I delete the records: a) When the user runs the report a second time, with different parameters. b) After the user exits, as part of a DB-wide clean-up procedure (Function) that dumps everything with the user's session key.

Re: [SQL] pl/pgsql Limits

2001-01-22 Thread Ian Harding
Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> writes: > >> As it is known that any funtion, written in pl/pgsql, can only > >> retrun one tuple. I am just wondering it were true as well for function > >> written in C language. I need to write few function that will retrun > >> mulitiple rows s

Re: [SQL] pl/pgsql Limits

2001-01-22 Thread Ian Harding
Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> writes: > >> As it is known that any funtion, written in pl/pgsql, can only > >> retrun one tuple. I am just wondering it were true as well for function > >> written in C language. I need to write few function that will retrun > >> mulitiple rows s

Re: [SQL] pl/pgsql Limits

2001-01-13 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: >> As it is known that any funtion, written in pl/pgsql, can only >> retrun one tuple. I am just wondering it were true as well for function >> written in C language. I need to write few function that will retrun >> mulitiple rows satsifying a certain set of

Re: [SQL] pl/pgsql Limits

2001-01-13 Thread Jan Wieck
Najm Hashmi wrote: > Hi All, > As it is known that any funtion, written in pl/pgsql, can only > retrun one tuple. I am just wondering it were true as well for function > written in C language. I need to write few function that will retrun > mulitiple rows satsifying a certain set of conditi

[SQL] pl/pgsql Limits

2001-01-12 Thread Najm Hashmi
Hi All, As it is known that any funtion, written in pl/pgsql, can only retrun one tuple. I am just wondering it were true as well for function written in C language. I need to write few function that will retrun mulitiple rows satsifying a certain set of conditions. Where I can get some ex