public inbox for [email protected]  

help / color / mirror / Atom feed

From: Selena Deckelmann <[email protected]>
To: Terminal Station <[email protected]>
Cc: [email protected]
Subject: Re: Migration issue
Date: Sun, 2 Mar 2008 16:26:41 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Sun, Mar 2, 2008 at 3:18 PM, Terminal Station <[email protected]> wrote:
> Url : http://pugs.postgresql.org/directory

>     * warning: pg_query() [function.pg-query]: Query failed: ERROR:
>  function left(character varying, integer) does not exist LINE 1:
>  SELECT count(DISTINCT(LEFT(term_data.name, 1))) FROM node no... ^
>  HINT: No function matches the given name and argument types. You may
>  need to add explicit type casts. in
>  /usr/local/www/drupal5/includes/database.pgsql.inc on line 125.

[trimmed]

This is not a casting problem.

The problem is the LEFT() function call.  This is a mysql-specific
function that returns the left-most characters. I fixed it by creating
a function that just uses SUBSTR() instead.

But there's another bug :(

And, I fixed it.  There was a missing column in a GROUP BY.

-selena


-- 
Selena Deckelmann
PDXPUG - Portland PostgreSQL Users Group
http://pugs.postgresql.org/pdx
http://www.chesnok.com/daily

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Migration issue
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox