Search Postgresql Archives

Re: Can interval take a value from a field?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2008-09-09 at 17:03 -0600, Jeff Ross wrote:
> select
>          ts_date as "Transcript Date",
>          ts_expiration_date as "Current Expiration Date",
>          expiration_value as "Expiration Interval"
>          from transcript, training_expiration_value where
>          ts_training_id = trgexpd_trg_id and
>          ts_training_id in (select cda_training_number from cdas) and
>          ts_expiration_date != ts_date + interval 'expiration_value';
> 
> and I'm getting the following error:
> 
> ERROR:  invalid input syntax for type interval: "expiration_value"

This error is saying that it is trying to convert the string
'expiration_value' to an interval.

What you really want it to convert the string value held inside a
variable named "expiration_value" to an interval.

For that, you need to do expiration_value::interval

Regards,
	Jeff Davis




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux