Hi Kumar,
It is possible to pass an array to a PL/pgSQL
function, but I believe you must specify the length of the array (at least doing
so works for me). E.g. "varchar(20)".
Regards,
George
- Original Message -
From:
Kumar
To: psql
Sent: Wednesday, October 08, 2003
Hi Kumar,
Looks like I got up too early this morning -
please ignore my previous reply re: varchar(30) (I was looking at the wrong
function :-( ).
I do use arrays in Pl/pgSQL functions, and have
defined them as you did, e.g. varchar[], which does not return an error.
What version of
I know there is a simple solution, but I can't remember what it is. :(
I have two similar tables. I want to update the fields from one table to
contain the values form the other. The two tables are:
laptop.freshports.org=# \d commit_log_ports
Table public.commit_log_ports
Column |
Dan,
UPDATE commit_log_ports_elements X
SET X.needs_refresh = CLP.needs_refresh,
X.port_version = CLP.port_version,
X.port_revision = CLP.port_revision
FROM commit_log_ports CLP
WHERE X.commit_log_id = CLP.commit_log_id
You can always ask this kind of thing on IRC .
On Wed, 8 Oct 2003, Josh Berkus wrote:
UPDATE commit_log_ports_elements X
IIRC, PostgreSQL doesn't like aliases of the
update table, so I think you'll need to spell it
out in the WHERE.
SET X.needs_refresh = CLP.needs_refresh,
X.port_version = CLP.port_version,
On Wed, 8 Oct 2003, Josh Berkus wrote:
Dan,
UPDATE commit_log_ports_elements X
SET X.needs_refresh = CLP.needs_refresh,
X.port_version = CLP.port_version,
X.port_revision = CLP.port_revision
FROM commit_log_ports CLP
WHERE X.commit_log_id = CLP.commit_log_id
Thanks