Re: Section 4.1.2.7 contains false information

2019-04-09 Thread David G. Johnston
On Tue, Apr 9, 2019 at 3:03 PM Jind?ich Vavru?ka wrote: > Dear Tom, it works only in psql, it does not work when you talk to the > server using postgresql protocol. That is my point. > > e.g. in the following code the query causes Syntax error (see the text in > red). That means it does not work.

RE: Section 4.1.2.7 contains false information

2019-04-09 Thread Jind?ich Vavru?ka
ame, startUtc, endUtc, format] ).then( result => { if( result.rowCount > 0 ) { return result.rows[0].contest_key } else { return undefined; } }); } ... } -Original Message----- From: Tom Lane Sent: Tuesday, April 9, 2019 5:57 PM To: jindr...@vavruska.cz C

Re: Section 4.1.2.7 contains false information

2019-04-09 Thread Tom Lane
PG Doc comments form writes: > QUOTE: > The CAST() syntax conforms to SQL. The type 'string' syntax is a > generalization of the standard: SQL specifies this syntax only for a few > data types, but PostgreSQL allows it for all types. The syntax with :: is > historical PostgreSQL usage, as is the f