Sindre•8mo ago

postgres sql bind varaiables

select now() - interval '$1' as end is there a way to get $1 to work

6 Replies

rubenf•8mo ago

yes, $1::text

Sindre•8mo ago

Wow. nice AI! thanks

Sindre•8mo ago

haha. but it did not work :\

Sindre•8mo ago

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

rubenf•8mo ago

1 year but let me find the fix this works: select interval '1'::text ' year'; so try this: ``` select interval $1::text ' year';

```
select concat($1::text, ' year')::interval;

```
select concat($1::text, ' year')::interval;

Sindre•8mo ago

thanks! that worked