Re: Trying to select records via matching timestamptz with

On Wed, 9 Aug 2006, ben wilko wrote:

>
> Hi Guys
>
> Trying to select records via matching timestamptz with varchar parameters in postgres 8.1, using the 8.1-404 JDBC3
driver.
> We're also running Java 1.5.0-05.
>
> CREATE OR REPLACE FUNCTION return_daily_card_list(d "varchar", m "varchar", y "varchar")
>   RETURNS refcursor AS
> $BODY$
> declare
>     pointer refcursor;
> begin
>     open pointer for
>         select *
>         from daily_time_record
>         where
>  if
>  d = SELECT EXTRACT(YEAR FROM daily_time_record.daily_time_card_date)
>  and
>  m = SELECT EXTRACT(MONTH FROM daily_time_record.daily_time_card_date)
>  and
>  y = SELECT EXTRACT(DAY FROM daily_time_record.daily_time_card_date)
>  and if;

I think you want something like:

     open pointer for
         select *
         from daily_time_record
         where
  d = EXTRACT(YEAR FROM daily_time_record.daily_time_card_date)
  and
  m = EXTRACT(MONTH FROM daily_time_record.daily_time_card_date)
  and
  y = EXTRACT(DAY FROM daily_time_record.daily_time_card_date);