postgresql: store result of sql query in variable

Question

I'm trying to store the result of a sql query, which should be a single date, in a variable. I'm doing this because I plan to reuse the variable several times throughout the rest of the script. I've tried the following:

DO
$$
DECLARE
  date_ordered date;
BEGIN
  date_ordered := SELECT MIN(event_date) FROM event;
END;
$$

Unfortunately I'm getting a syntax error at SELECT. Any idea what I'm doing wrong here or if this is even possible?

sticky bit · Accepted Answer · 2018-08-23 23:16:00Z

3

Enclose the query in parenthesis.

...
date_ordered := (SELECT MIN(event_date) FROM event);
...

Or use SELECT ... INTO.

...
SELECT MIN(event_date) INTO date_ordered FROM event;
...

answered Aug 23, 2018 at 23:16

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql: store result of sql query in variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related