diff options
| author | Bruce Momjian | 2006-02-10 00:39:04 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2006-02-10 00:39:04 +0000 |
| commit | c01999a557b5c9ae200a95024539b823dbcfacd5 (patch) | |
| tree | 2e9c7fdc2c0a5042821d98e376d7377230309d1b /src/test | |
| parent | 593763c086e76159cc9562e9b024ad772af9d5fe (diff) | |
Allow psql multi-line column values to align in the proper columns
If the second output column value is 'a\nb', the 'b' should appear
in the second display column, rather than the first column as it
does now.
Change libpq's PQdsplen() to return more useful values.
> Note: this changes the PQdsplen function, it can now return zero or
> minus one which was not possible before. It doesn't appear anyone is
> actually using the functions other than psql but it is a change. The
> functions are not actually documentated anywhere so it's not like we're
> breaking a defined interface. The new semantics follow the Unicode
> standard.
BACKWARD COMPATIBLE CHANGE.
The only user-visible change I saw in the regression tests is that a
SELECT * on a table where all the columns have been dropped doesn't
return a blank line like before. This seems like a step forward.
Martijn van Oosterhout
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 1 | ||||
| -rw-r--r-- | src/test/regress/expected/prepare.out | 26 |
2 files changed, 13 insertions, 14 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index b6e46393b4d..02723d62ecc 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -797,7 +797,6 @@ alter table atacc1 drop c; alter table atacc1 drop d; alter table atacc1 drop b; select * from atacc1; - -- (1 row) diff --git a/src/test/regress/expected/prepare.out b/src/test/regress/expected/prepare.out index 3532953f552..df5dc5dde26 100644 --- a/src/test/regress/expected/prepare.out +++ b/src/test/regress/expected/prepare.out @@ -149,18 +149,18 @@ PREPARE q7(unknown) AS SELECT name, statement, parameter_types FROM pg_prepared_statements ORDER BY name; name | statement | parameter_types -------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------- - q2 | PREPARE q2(text) AS - SELECT datname, datistemplate, datallowconn - FROM pg_database WHERE datname = $1; | {text} - q3 | PREPARE q3(text, int, float, boolean, oid, smallint) AS - SELECT * FROM tenk1 WHERE string4 = $1 AND (four = $2 OR - ten = $3::bigint OR true = $4 OR oid = $5 OR odd = $6::int); | {text,integer,"double precision",boolean,oid,smallint} - q5 | PREPARE q5(int, text) AS - SELECT * FROM tenk1 WHERE unique1 = $1 OR stringu1 = $2; | {integer,text} - q6 | PREPARE q6 AS - SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2; | {integer,name} - q7 | PREPARE q7(unknown) AS - SELECT * FROM road WHERE thepath = $1; | {path} +------+------------------------------------------------------------------+-------------------------------------------------------- + q2 | PREPARE q2(text) AS | {text} + : \x09SELECT datname, datistemplate, datallowconn + : \x09FROM pg_database WHERE datname = $1; + q3 | PREPARE q3(text, int, float, boolean, oid, smallint) AS | {text,integer,"double precision",boolean,oid,smallint} + : \x09SELECT * FROM tenk1 WHERE string4 = $1 AND (four = $2 OR + : \x09ten = $3::bigint OR true = $4 OR oid = $5 OR odd = $6::int); + q5 | PREPARE q5(int, text) AS | {integer,text} + : \x09SELECT * FROM tenk1 WHERE unique1 = $1 OR stringu1 = $2; + q6 | PREPARE q6 AS | {integer,name} + : SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2; + q7 | PREPARE q7(unknown) AS | {path} + : SELECT * FROM road WHERE thepath = $1; (5 rows) |