Search Postgresql Archives

Re: SQL WHERE: many sql or large IN()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I've never seen this before.
Is this PG specific or generic SQL that I've never been exposed to?

	http://www.postgresql.org/docs/8.2/interactive/sql-values.html
VALUES conforms to the SQL standard, except that LIMIT and OFFSET are PostgreSQL extensions.

It doesn't seem like much at first glance, but it's really useful. It's your kleenex temp table. It can select the rows you want from a table in the order you want, update a table, replacing several values with several others (as a before=>after correspondence table) and many other things. It is more powerful than IN() because you can use columns of the VALUES() in any part of your query, updating, ordering, etc.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux