Home > mailing lists

Setting a default value for a select statement without results - Mailing list pgsql-sql

From	JORGE MALDONADO
Subject	Setting a default value for a select statement without results
Date	February 6, 2013 03:23:13
Msg-id	CAAY=A7_cM2ZrO9oD=_pbuX6vdNiVST3iXLfRDZ5_YHASoABZBg@mail.gmail.com Whole thread Raw
Responses	Re: Setting a default value for a select statement without results Re: Setting a default value for a select statement without results Re: Setting a default value for a select statement without results
List	pgsql-sql

I have an UPDATE query with the following general structure:

UPDATE table1 SET (SELECT field FROM table2 WHERE conditions ORDER BY order_field LIMIT 1)

Is it possible to assign a default value in case no results are returned by the SELECT statement?

Respectfully,

Jorge Maldonado

From: Dev Kumkar
Date: 05 February 2013, 20:12:18
Subject: Querying multiple database

From: Anton Gavazuk
Date: 06 February 2013, 03:35:06
Subject: Re: Setting a default value for a select statement without results