#8780: PostgreSQL - Serial column - should not numerically, not like string

SachinPrakash reported 2013-04-29T16:31:24Z · swissarmyknife(*) last modified 2013-07-16T20:16:19Z

PostgreSQL - Serial column - should not numerically, not like string

Dev	ivangron
QA	swissarmyknife(*)

Priority	Low
Complexity	Unknown

Component	Q Analyzer - Grid Results
Version	12.0

When sorting a serial column in PostgreSQL, in a result set, ADS appears to perform a string based sort. e.g.

100

109

Instead of the expected integer based sort:

100

109

All Comments (5) Change History

SachinPrakash 2013-04-29T16:36:25Z · (edited)

http://www.postgresql.org/docs/8.1/static/datatype.html#DATATYPE-SERIAL

ivangron 2013-04-29T17:31:08Z

Serial and BigSerial where been declared as a Numeric and String. This has been fixed for postgres & greenplum. They are now Int and BigInt respectively.

tariqrahiman 2013-04-29T21:37:30Z

Works in 13.0.0-9

ivangron 2013-07-15T17:01:53Z

needs to be fixed for version 12 as well.

ivangron 2013-07-15T17:08:10Z

fixed for version 12

Search Tips

Aqua Data Studio / nhilam

PostgreSQL - Serial column - should not numerically, not like string

Issue #8780

Completion

Search Tips

Aqua Data Studio / nhilam

Title

PostgreSQL - Serial column - should not numerically, not like string

Issue #8780

Completion