On Fri, Sep 22, 2006 at 11:38:12PM -0700, Ben wrote:
> Does anybody have a stored proc they'd like to share (preferably pl/
> pgsql) that generates the power set of an array?
Here's an attempt:
CREATE FUNCTION powerset(a anyarray) RETURNS SETOF anyarray AS $$
DECLARE
retval a%TYPE;
alow
On Thu, 2006-09-21 at 23:39 -0400, Jim Nasby wrote:
> On Sep 14, 2006, at 11:15 AM, Russ Brown wrote:
> > We recently upgraded our trac backend from sqlite to postgres, and I
> > decided to have a little fun and write some reports that delve into
> > trac's subversion cache, and got stuck with a qu
SELECT convert(myfield,'LATIN2','WIN1250') FROM tbl;
ERROR: character 0x828e of encoding "MULE_INTERNAL" has no equivalent in
"WIN1250"
I know I have few characters like this one in table with about 1.000.000
rows.
How to avoid such error and show eg. ? instead of error , or how to replace
such
