; What's wrong with Pavel's correct and to-the-point answer?
No need actually to cast... just use current_date without the quotes.
Its not a string.
>
> Tim
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
&
calls.sql | psql holly
>
> ERROR: "$1" is declared CONSTANT
>
> CONTEXT: compilation of PL/pgSQL function "gen_simultaneous_calls" near
> line 7
>
>
mystart and mystop are constants...
you could declare variables and copy those into them, and the mo
tribution or use of the contents of this information
> is prohibited. *
>
> * *
>
> *If you have received this electronic transmission in error, please notify
> the sender immediately by a "reply to sender only" message and destroy all
> electronic and hard copies of the communication, including attachments.*
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/
t;> > INTO
>> >> > users
>> >> > (
>> >> > aur_id
>> >> > , aur_username
>> >> > , aur_is_account_enabled
>> >> > , aur_created_by
>> >> > , au
>> > My motivation for doing this is to reduce network round trips, instead
>> > of
>> > having 1 call per record to be sent to the db, I can have 1 call passing
>> > all
>> > values which I wish to store in the database.
>> >
>> &g
