Skip site navigation (1) Skip section navigation (2)

MS Access to PostgreSQL

From: William Shatner <shatner(dot)william(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org,pgsql-jdbc(at)postgresql(dot)org
Subject: MS Access to PostgreSQL
Date: 2005-03-11 17:19:35
Message-ID: 9af1b1990503110919553a66ec@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbcpgsql-novice
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?


Many Thanks,
B

Responses

pgsql-novice by date

Next:From: Shelby CainDate: 2005-03-11 17:31:36
Subject: Re: MS Access to PostgreSQL
Previous:From: Kumar SDate: 2005-03-11 16:45:15
Subject: complex queries

pgsql-jdbc by date

Next:From: Shelby CainDate: 2005-03-11 17:31:36
Subject: Re: MS Access to PostgreSQL
Previous:From: Sergio LobDate: 2005-03-11 15:55:35
Subject: Re: [BUGS] BUG #1523: precision column value returned from

pgsql-general by date

Next:From: Christopher BrowneDate: 2005-03-11 17:19:42
Subject: Re: Best practices: Handling Daylight-saving time
Previous:From: tonyDate: 2005-03-11 16:57:30
Subject: speak of the devil

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group