Re: [SQL] Array in plpgsql with composite type

2005-06-20 Thread Michael Fuhr
On Mon, Jun 20, 2005 at 01:31:20PM -0300, grupos wrote: > > I need to make an array with composite type (varchar, float8) to get > data from a table (description and price) BUT I am having no success... According to the "Arrays" section of the "Data Types" chapter in the documentation, arrays o

[SQL] Array in plpgsql with composite type

2005-06-20 Thread grupos
Hi Guys! I need to make an array with composite type (varchar, float8) to get data from a table (description and price) BUT I am having no success... I searched a lot on the internet without success. On the PostgreSQL manual there is no information how to handle array with plpgsql with compos

Re: [SQL] Array in plpgsql

2001-08-19 Thread Christopher Sawtell
On Mon, 20 Aug 2001 08:41, omid omoomi wrote: > hi all, > Can some body show me how to declare a variable of type "array" in a > function using plpgsql ? http://www.postgresql.org/idocs/index.php?non-atomic-values.html#AEN1244 -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021

[SQL] Array in plpgsql

2001-08-19 Thread omid omoomi
hi all, Can some body show me how to declare a variable of type "array" in a function using plpgsql ? TIA Omid Omoomi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ---(end of