quote_boolean() and friends missing

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: quote_boolean() and friends missing
Date: 2005-06-20 13:08:16
Message-ID: 1119272896.4688.7.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I'm writing an application with a lot of PL/pgSQL and am constructing
SQL queries on the fly. The quote_literal() and quote_ident() functions
proved very much needed. Similarly, I need functions that return the SQL
representation of all the other datatypes, not just TEXT: quote_boolean
(), quote_date() and so on. For the sake of completeness I think these
functions should exist. While the use of to_char() resp. decode() for
some types is possible, it does feel like a workaround to me. Opinions?
Do these functions belong in the PostgreSQL core?

--
Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-06-20 13:19:14 Re: [PATCHES] default database creation with initdb
Previous Message Alfranio Correia Junior 2005-06-20 10:03:45 HOOKS for Synchronous Replication