Re: [SQL] UPDATE one table with values from another

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_lo

Re: [SQL] UPDATE one table with values from another

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, > >X

Re: [SQL] UPDATE one table with values from another

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 .

[SQL] UPDATE one table with values from another

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 |

Re: [SQL] Possible to have array as input paramter for a function?

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 P

Re: [SQL] Possible to have array as input paramter for a function?

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

[SQL] Possible to have array as input paramter for a function?

Dear Friends,   I am working with Postgres 7.3.4 on RH Linux 7.2 and my windows client is PgAdmin 3.   Is it possible to pass a Varchar[] as a input parameter for a PL/pgSQL function. While I tried it give a error     Type "varchar[]" does not exists.   Does this is supported in Postgres?  

[SQL] security definer function

Hi I have two functions: A) function defined with "SECURITY DEFINER" B) function defined with "SECURITY INVOKER" Function A calls function B. How is the function b called - with rights of definer of function A, or rather with rights of caller of function A ? Regards, Tomasz Myrta -

Re: [SQL] PG equivalent to Sybase varbinary

On Monday 06 October 2003 15:40, Bill Pfeiffer wrote: > Anybody know what the Postgresql equivalent to a Sybase varbinary data type > is? I have a package that provides ddl to store a 40 byte/char? varbinary > column in a table and it is failing against postrgresql. Sounds like "bytea" to me - or