Thread: How can I..

How can I..

From

"Eric Day"

Date:

27 October 2001, 18:23:08

How do I create a stored procedure which would return a few records with a
few columns each ?

Regards,
Eric

Attachment

winmail.dat

Re: How can I..

From

Chris Ruprecht

Date:

27 October 2001, 19:31:55

Eric,

>How do I create a stored procedure which would return a few records with a
>few columns each ?
>
>Regards,
>Eric


Create a temp table, delete all it's records. Then have run your
procedure which will create records in the temp table. You have
access to the records in the temp table from your calling procedure.
Sorry, but there is no data type 'record' which can be used to return
a records (row, tuple, etc.) in PostGreSQL at the moment.

Best regards,
Chris
--
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Vacuumdb warnings

From

Tariq Muhammad

Date:

29 October 2001, 15:27:13

When issue the vacuumdb command I get the following response:

NOTICE:  RegisterSharedInvalid: SI buffer overflow
NOTICE:  InvalidateSharedInvalid: cache state reset

Can anyone please help, is there anything needs to be done ???

Tks

Tariq Muhammad
Liberty RMS
tmuhamma@libertyrms.info
v:416-646-3304 x 111
c:416-993-1859
p:416-381-1457