postgres sql bind varaiables
select now() - interval '$1' as end
is there a way to get $1 to work
6 Replies
yes, $1::text
Wow. nice AI! thanks
haha. but it did not work :\
did not work either. but then I guess it just how it is
1 year
but let me find the fix
this works: select interval '1'::text ' year';
so try this:
```
select interval $1::text ' year';
thanks! that worked
