RE: [SQL] UPDATE subselect? - Mailing list pgsql-sql

From Jackson, DeJuan
Subject RE: [SQL] UPDATE subselect?
Date
Msg-id D05EF808F2DFD211AE4A00105AA1B5D20B8986@cpsmail
Whole thread Raw
List pgsql-sql
try:UPDATE categorySET parent[0] = mfr.oidFROM mfrWHERE mfr.name='canon';
-DEJ

> José Soares wrote:
> > 
> > Take a look at PostgreSQL User's Guide
> > Chapter 10. Arrays
> 
> Which doesn't help me because I need to update individual array elements
> from subselects.
> 
> > 
> > syntax:
> > INSERT INTO SAL_EMP
> >     VALUES ('Bill',
> >     '{10000, 10000, 10000, 10000}',
> >     '{{"meeting", "lunch"}, {}}');
> > 
> > José
> > 
> > Chris Bitmead ha scritto:
> > 
> > > What is the correct syntax for this UPDATE?
> > >
> > > CREATE TABLE category (
> > >   name text,
> > >   image text,
> > >   url text,
> > >   parent oid[]
> > > );
> > > update category set parent = '{0,0}' where name='slr';
> > > So far so good...
> > > update category set parent[0] = (SELECT oid from mfr where
> > > name='canon');
> > > ERROR:  parser: parse error at or near "select"
> > >
> > > --
> > > Chris Bitmead
> > > http://www.bigfoot.com/~chris.bitmead
> > > mailto:chris.bitmead@bigfoot.com
> 
> -- 
> Chris Bitmead
> http://www.bigfoot.com/~chris.bitmead
> mailto:chris.bitmead@bigfoot.com


pgsql-sql by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [SQL] UPDATE subselect?
Next
From: Henrik Pedersen
Date:
Subject: How to compare Datetime