From: | Shelby Cain <alyandon(at)yahoo(dot)com> |
---|---|
To: | William Shatner <shatner(dot)william(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: MS Access to PostgreSQL |
Date: | 2005-03-11 17:31:36 |
Message-ID: | 20050311173136.35598.qmail@web50101.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc pgsql-novice |
--- William Shatner <shatner(dot)william(at)gmail(dot)com> wrote:
> I have recently migrated from MS Access to
> PostgreSQL.Previously I had
> a SQL command
>
> ResultSet aGroupResultSet =
> aGroupPathStmt.executeQuery(
> "SELECT \"groupID\",\"fullpath\" FROM
> \"groups\" WHERE
> \"fullpath\" Like '" +
> aPath + "'");
>
>
>
> where aPath was equal to 'folder\another folder\%'.
>
> The field to be edited stores the full path in the
> format
> 'folder\folder1\folder2' and so on...
> The purpose being to change all groups at this level
> of the
> hieracarchy and below, this was achieved using the
> '%' in Access, this
> however doesn't seem to work in PostgreSQL, it
> doesn't error out but
> it just seems to see the '%' as a normal character.
>
> How can this be done in PostgreSQL?
>
I suspect that, unlike Access, PostgreSQL will
intrepret C-style escape sequences (ie: \r, \n, \t) so
you'll need to properly escape the backslash in aPath
like so:
folder1\\folder2\\folder3
Regards,
Shelby Cain
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
From | Date | Subject | |
---|---|---|---|
Next Message | Richard_D_Levine | 2005-03-11 17:32:55 | Re: speak of the devil |
Previous Message | Christopher Browne | 2005-03-11 17:19:42 | Re: Best practices: Handling Daylight-saving time |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-03-11 17:47:10 | Re: MS Access to PostgreSQL |
Previous Message | William Shatner | 2005-03-11 17:19:35 | MS Access to PostgreSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-03-11 17:47:10 | Re: MS Access to PostgreSQL |
Previous Message | William Shatner | 2005-03-11 17:19:35 | MS Access to PostgreSQL |