| From: | "Brian P(dot) Mann" <bpmann(at)modempool(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: query failed , don't know why |
| Date: | 2000-06-23 22:04:31 |
| Message-ID: | 005501bfdd5f$02633170$0a00a8c0@modempool.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
shouldn't that be m.payments and not m,payments?
Brian
----- Original Message -----
From: "Jeff MacDonald" <jeff(at)pgsql(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>; <pgsql-hackers(at)postgresql(dot)org>
Sent: Friday, June 23, 2000 2:53 PM
Subject: [HACKERS] query failed , don't know why
> 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
>
> i'm running postgresql 7.0.2 with freebsd 4.0 stable
>
> jeff
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2000-06-24 03:22:10 | Re: About the pid and opts files |
| Previous Message | Lamar Owen | 2000-06-23 20:12:07 | Re: Mandrake RPMS, was "Building PostgreSQL 7.0.1 documentation" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-06-24 03:31:20 | Re: query failed , don't know why |
| Previous Message | Andrés Mauricio Marín Restrepo | 2000-06-23 22:03:35 | HI! Problems with cursors into triggers |