I assume this is not something for our PostgreSQL CVS, even the later SRF implementation.
--------------------------------------------------------------------------- John Hansen wrote: > Attached, array -> rows iterator. > > select * from unnest(array[1,2,3,4,5]); > > Unnest > --------------- > 1 > 2 > 3 > 4 > 5 > 5 rows > > The switch statement could probably be done in a different way, but > there doesn't seem to be any good examples of how to return anyitem. If > anyone have a better way, please let me know. > > Does anyone know how to check individual array elements for NULL values? > PG_ARG_ISNULL() seems to return true if ANY array element is null; ex:: > array[1,2,3,null,4,5] > > Comments / improvements welcome. > > Kind regards, > > John > Content-Description: Makefile [ Attachment, skipping... ] Content-Description: unnest.c [ Attachment, skipping... ] Content-Description: unnest.sql [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
