Re: syntax error during function call

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: "Aycock, Jeff R(dot)" <JEFF(dot)R(dot)AYCOCK(at)saic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: syntax error during function call
Date: 2010-01-27 16:12:34
Message-ID: 162867791001270812k4bcee3f1j3e33c1dac232443a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> ERROR:  syntax error at or near "("
>
> LINE 1: SELECT *, $1, now() INTO schema_1.(table_A) FROM schema_2.(table_A)
> where created_dt between $2 and $3;
>
>

schema_1.(table_A) is nonsense. have to be "schema_1"."table_A"

regards
Pavel Stehule

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aycock, Jeff R. 2010-01-27 16:27:58 Re: syntax error during function call
Previous Message Aycock, Jeff R. 2010-01-27 16:10:05 Re: syntax error during function call