Re: Showing table comments with psql

2019-01-04 Thread Mark Jeffcoat
avel │ 0 bytes │ this is a table comment │ > └┴┴───┴───┴─┴─┘ > (1 row) > I was so close! That works; thank you very much for your help, Pavel. -- Mark Jeffcoat Austin, TX

Showing table comments with psql

2019-01-04 Thread Mark Jeffcoat
'test_table'); objoid | classoid | objsubid | description +--+--+- 714760 | 1259 | 0 | this is a table comment (1 row) -- Mark Jeffcoat Austin, TX

Re: Join condition parsing puzzle

2018-08-26 Thread Mark Jeffcoat
On Thu, Aug 23, 2018 at 4:51 PM, Tom Lane wrote: > > Mark Jeffcoat writes: > > I would have claimed before seeing this example that it wasn't even > > grammatical; I thought the only legal place to write the ON clause was > > immediately after the JOIN. Appar

Join condition parsing puzzle

2018-08-23 Thread Mark Jeffcoat
ion_a.id_v = relation_b.id_v); I would have claimed before seeing this example that it wasn't even grammatical; I thought the only legal place to write the ON clause was immediately after the JOIN. Apparently not. How should I read this query? I'd appreciate any help understanding this. -- Mark Jeffcoat Austin, TX