Re: Request for builtin function: Double_quote - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Request for builtin function: Double_quote
Date
Msg-id 200206180735.JAA21303@rodos
Whole thread Raw
In response to Request for builtin function: Double_quote  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Josh, 
I'm not sure what you mean by 'builtin C function'. 
There is one already size_t PQescapeString (char *to, const char *from, size_t length); 
Or do you mean a String Function like substring(string [from integer] [for integer]) 
I would rather call it 'builtin sql function'. 

Regards, Christoph 

> 
> Folks,
> 
> Given the amount of qoute nesting we do in Postgres, I thought that we need a
> function that handles automatic doubling of quotes within strings.   I've 
> written one in PL/pgSQL (below).  I'd really love to see this turned into a 
> builtin C function.
> 
> -Josh
> 


pgsql-sql by date:

Previous
From: "Andy Pearce"
Date:
Subject: Users
Next
From: "Ulrich Sprick"
Date:
Subject: Re: Limiting database size