| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff MacDonald <jeff(at)pgsql(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] query failed , don't know why |
| Date: | 2000-06-24 04:37:09 |
| Message-ID: | 20421.961821429@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
Jeff MacDonald <jeff(at)pgsql(dot)com> writes:
> UPDATE members m,payments p SET m.status = 2 WHERE p.paydate > 'now'::datetime - '1 month'::timespan and p.productid = 'xxxxxxx' and m.gid = p.gid
> i'm trying to run that query and i'm getting
> "parse error near m"
> but it looks ok to me
OK according to what reference? SQL92 doesn't allow anything but a
simple <table name> between UPDATE and SET --- no aliases, much less
multiple table names.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-06-24 04:53:20 | Re: 64-bit sequences |
| Previous Message | Tom Lane | 2000-06-24 04:23:13 | Re: 64-bit sequences |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | K Parker | 2000-06-24 05:14:42 | Re: Wildcard in date field |
| Previous Message | Thomas Lockhart | 2000-06-24 03:31:20 | Re: query failed , don't know why |