Re: Perl DBI and placeheld values

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Perl DBI and placeheld values
Дата
Msg-id 20030130144102.GB32517@wolff.to
обсуждение исходный текст
Ответ на Perl DBI and placeheld values  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-general
On Wed, Jan 29, 2003 at 22:30:49 +0000,
  "Nigel J. Andrews" <nandrews@investsystems.co.uk> wrote:
>
> So just how do others manage this situation without resorting to special casing
> everything?

In this particular case you could use 'now' instead of current_timestamp.
In some other cases you might be able to use default to use the default
value.
In general you probably want two different sql statements and not try
to mix constant data and function calls in the same prepared statement.

В списке pgsql-general по дате отправления:

Предыдущее
От: Renê Salomão
Дата:
Сообщение: Weird Behavior!!!
Следующее
От: "Patrick Bye (WFF)"
Дата:
Сообщение: Re: Problem starting postmaster at startup