| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Dmitriy Igrishin <dmitigr(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
| Subject: | Re: A cronjob for copying a table from Oracle |
| Date: | 2010-12-10 18:01:18 |
| Message-ID: | 4D026AEE.5030807@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/10/2010 09:45 AM, Dmitriy Igrishin wrote:
> Huh! Yes, indeed ! But how is it possible ?! I see
> EMAIL = _EMAIL,
> EMAILID = _EMAILID,
>
> rather than
>
> EMAIL = $7,
> EMAILID = $8,
>
> in the function definition...
My guess the reversal is taking place in the PHP code. The table
definition and the argument list to the Pg function have one order for
emailid,email and the update and insert statements have another;
email,emailid. I would guess that the PHP is building the row variables
using the SQL statement order and than passing that to the Pg function
which has a different order.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitriy Igrishin | 2010-12-10 18:03:25 | Re: A cronjob for copying a table from Oracle |
| Previous Message | Dmitriy Igrishin | 2010-12-10 17:58:12 | Re: Fwd: Extended query protocol and exact types matches. |