| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: syntax error during function call |
| Date: | 2010-01-27 16:34:35 |
| Message-ID: | 20100127163435.GA7476@tux |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Aycock, Jeff R. <JEFF(dot)R(dot)AYCOCK(at)saic(dot)com> wrote:
> Pavel,
>
> Per your suggestion I modified one line below BEGIN to look like this:
>
> EXECUTE 'SELECT *, $1, now() INTO "schema_1".'||"whoami"||' FROM "schema_2".'||"whoami"||' where created_dt between $2 and $3;'
^^^^^^ ^^^^
How ist the correct table-name?
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-01-27 16:34:45 | Re: Problem after installing triggering function |
| Previous Message | Adrian Klaver | 2010-01-27 16:33:07 | Re: syntax error during function call |