Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Using array in Functions plpgsql



Hi,

I'm trying to use array in a function but it seems to be a little bit harder than i thought.
So i have a function with 2 parameters 'INTEGER[]' and 'INTEGER'
in this function i would like to loop in the array for realizing dynamic insert query like this
INSERT INTO myTable ($2 , current value of $1)

Is it possible ?

Thanks


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group