Postgres Pro
Downloads
Home   >   mailing lists

Re: syntax error during function call - Mailing list pgsql-general

From Pavel Stehule
Subject Re: syntax error during function call
Date
Msg-id 162867791001270812k4bcee3f1j3e33c1dac232443a@mail.gmail.com
Whole thread Raw
In response to syntax error during function call  ("Aycock, Jeff R." <JEFF.R.AYCOCK@saic.com>)
Responses Re: syntax error during function call  ("Aycock, Jeff R." <JEFF.R.AYCOCK@saic.com>)
List pgsql-general
Tree view 
>
> 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

pgsql-general by date:

Previous
From: "Aycock, Jeff R."
Date:
Subject: Re: syntax error during function call
Next
From: "Aycock, Jeff R."
Date:
Subject: Re: syntax error during function call