so 15. 8. 2020 v 7:35 odesílatel Aleksey M Boltenkov <holybolt@xxxxxxxxxx> napsal:
Is this a bug?Executing of malformed (quote symbols) select in psql results in unexpected behaviour:pg01:5432 postgres@db=# select 'any _expression_'any _expression_\d+;
List of relations
Schema │ Name │ Type │ Owner │ Size │ Description
════════╪══════════════════════════╪══════════╪══════════╪════════════╪══════════════
public │ geography_columns │ view │ postgres │ 0 bytes │
public │ geometry_columns │ view │ postgres │ 0 bytes │
public │ pg_buffercache │ view │ postgres │ 0 bytes │
public │ pg_stat_statements │ view │ postgres │ 0 bytes │
public │ raster_columns │ view │ postgres │ 0 bytes │
public │ raster_overviews │ view │ postgres │ 0 bytes │
public │ spatial_ref_sys │ table │ postgres │ 4616 kB │...
I tested psql-12 and psql-14 and I don't see this issue
Pavel
Aleksey M Boltenkov.
