From 0c88e559d1169b3038bbdb087c06362161e2e03c Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 16 Jun 2010 02:12:51 +0000 Subject: [PATCH] Add notes that CREATE/DROP CONVERSION is similar to CREATE/DROP TRANSLATION in the SQL standard. --- doc/src/sgml/ref/create_conversion.sgml | 5 +++-- doc/src/sgml/ref/drop_conversion.sgml | 7 +++++-- 2 files changed, 8 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/ref/create_conversion.sgml b/doc/src/sgml/ref/create_conversion.sgml index 108c6fb6ae..5c51d370dc 100644 --- a/doc/src/sgml/ref/create_conversion.sgml +++ b/doc/src/sgml/ref/create_conversion.sgml @@ -1,4 +1,4 @@ - + @@ -153,7 +153,8 @@ CREATE CONVERSION myconv FOR 'UTF8' TO 'LATIN1' FROM myfunc; CREATE CONVERSION is a PostgreSQL extension. There is no CREATE CONVERSION - statement in the SQL standard. + statement in the SQL standard, but a CREATE TRANSLATION + statement that is very similar in purpose and syntax. diff --git a/doc/src/sgml/ref/drop_conversion.sgml b/doc/src/sgml/ref/drop_conversion.sgml index b80de52f0a..64ccf4e3a9 100644 --- a/doc/src/sgml/ref/drop_conversion.sgml +++ b/doc/src/sgml/ref/drop_conversion.sgml @@ -1,4 +1,4 @@ - + @@ -86,7 +86,10 @@ DROP CONVERSION myname; There is no DROP CONVERSION statement in the SQL - standard. + standard, but a DROP TRANSLATION statement that + goes along with the CREATE TRANSLATION statement + that is similar to the CREATE CONVERSION + statement in PostgreSQL. -- 2.11.0