Is it possible to have a placeholder on the left side of a select
criteria?
eg:
SELECT CASE WHEN date_part('dow',?::date)=5
this bit is fine
THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00'
here the ? is being read as NULL ie, output from LOG
SELECT CASE WHEN
On Mon, 2005-02-14 at 18:41 +, mike wrote:
Is it possible to have a placeholder on the left side of a select
criteria?
yes
eg:
SELECT CASE WHEN date_part('dow',?::date)=5
this bit is fine
THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00'
here the ? is