Commit5ac3cd0

Thomas G. Lockhart

committed

Include example of Postgres' extended query syntax which allow one to omit

the FROM clause. e.g. "SELECT table.*".

1 parent4060456 commit5ac3cd0Copy full SHA for 5ac3cd0

File tree

+21

-0

lines changed

+21

-0

lines changed

Lines changed: 21 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -494,6 +494,27 @@ SELECT actors.name`
`494`	`494`	`</para>`
`495`	`495`
`496`	`496`	`<refsect2 id="R2-SQL-SELECT-4">`
	`497`	`+ <refsect2info>`
	`498`	`+ <date>1998-09-24</date>`
	`499`	`+ </refsect2info>`
	`500`	`+ <title>`
	`501`	`+ <acronym>Extensions</acronym>`
	`502`	`+ </title>`
	`503`	`+`
	`504`	`+ <para>`
	`505`	`+<productname>Postgres</productname> allows one to omit`
	`506`	`+the <command>FROM</command> clause from a query. This feature`
	`507`	`+was retained from the original PostQuel query language:`
	`508`	`+ <programlisting>`
	`509`	`+SELECT distributors.* WHERE name = 'Westwood';`
	`510`	`+`
	`511`	`+ did\|name`
	`512`	`+ ---+----------------`
	`513`	`+ 108\|Westward`
	`514`	`+ </programlisting>`
	`515`	`+ </para>`
	`516`	`+`
	`517`	`+ <refsect2 id="R2-SQL-SELECT-5">`
`497`	`518`	`<refsect2info>`
`498`	`519`	`<date>1998-09-24</date>`
`499`	`520`	`</refsect2info>`

Comments

(0)