| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to always run UPDATE FROM despite missing records in the source table? |
| Date: | 2019-01-13 11:25:53 |
| Message-ID: | 87r2dgn8l6.fsf@news-spur.riddles.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>>>>> "Alexander" == Alexander Farber <alexander(dot)farber(at)gmail(dot)com> writes:
Alexander> even though I wonder what is the (VALUES
Alexander> ('20.20.20.20'::inet)) v(ip) construct there, some temporary
Alexander> table which is then LEGT JOINed to the geoip table?
The SQL spec calls it a <table value constructor>. The VALUES clause
behaves like a SELECT that returns a fixed number of rows (1 or more)
whose columns contain the results of the specified expressions. The
v(ip) part is just a table and column alias (I omitted the optional AS
keyword out of long habit) to name the constructed table.
--
Andrew (irc:RhodiumToad)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zach van Rijn | 2019-01-13 14:13:26 | Re: Static PostgreSQL Binaries (Linux + Windows) |
| Previous Message | Alexander Farber | 2019-01-13 10:11:47 | Re: How to always run UPDATE FROM despite missing records in the source table? |