postgres sql bind varaiables

select now() - interval '$1' as end

select now() - interval '$1' as end

is there a way to get $1 to work

rubenf•3/19/24, 1:05 PM

yes, $1::text

SindreOP•3/19/24, 1:12 PM

Wow. nice AI! thanks

SindreOP•3/19/24, 1:12 PM

haha. but it did not work :\

SindreOP•3/19/24, 1:13 PM

did not work either. but then I guess it just how it is

rubenf•3/19/24, 1:13 PM

1 year

rubenf•3/19/24, 1:13 PM

but let me find the fix

rubenf•3/19/24, 1:14 PM

this works: select interval '1'::text || ' year';

rubenf•3/19/24, 1:14 PM

so try this:

rubenf•3/19/24, 1:15 PM

SindreOP•3/19/24, 1:17 PM

thanks! that worked