Hi,
I'm am programming in python using the Dabo modules. www.dabodev.com if your
interested. Dabo is a framework that provides an easy way to build desktop
app's. To clear a data entry form. I have been setting the where clause
to "where 1=0". This of course retrieves 0 records and my form w
On Saturday 02 May 2009 06:34:57 pm Craig Ringer wrote:
> johnf wrote:
> > I have a list (or array) of primary keys stored in a field (data type
> > text). I would like to use the list to retrieve all the data from a table
> > based on the list.
> >
I have a list (or array) of primary keys stored in a field (data type text).
I would like to use the list to retrieve all the data from a table based on
the list.
my text field contains:
'123,134,343,345'
I would to do something like the following:
Select * from table1 where table1.pkid in (
On Tuesday 24 February 2009 08:19:56 am Mark Stosberg wrote:
> Hello,
>
> I use PostgreSQL and the "cube" type to perform geo-spatial zipcode
> proximity searches. I'm wondering about the best practices also supporting
> a geo-spatial distance search based on a city name rather than zipcode.
>
> In
On Monday 16 February 2009 10:32:26 pm A. Kretschmer wrote:
> In response to johnf :
> > Hi,
> > I'm not to sure this is possible.
> >
> > I need to replace a primary key (pkid) with the value of a different
> > field. I have
> > pkid = 200
>
Hi,
I'm not to sure this is possible.
I need to replace a primary key (pkid) with the value of a different field.
I have
pkid = 200
attendid = 301
I need the pkid = 301
But there may or may not be a pkid that already exist that has the value of
301. The attendid is unique and the pkid data
On Friday 22 February 2008 01:35:47 am Bart Degryse wrote:
> Can you try this...
>
> CREATE OR REPLACE FUNCTION getfunctionaries(p_statecd integer)
> RETURNS SETOF t_functionaries AS
> $BODY$
> DECLARE
> rec t_functionaries%ROWTYPE;
> BEGIN
> FOR rec IN (
> SELECT f.functionaryid, f.categ
On Wednesday 06 February 2008 06:54:36 pm Medi Montaseri wrote:
> I suppose instead of AR and AP tables, I can just have one table called
> Entry (thanks Joe) with an attribute indicating AR vs AP.
I recommend you not do have only one table for transaction. AR and AP are
different animals an
On Wednesday 06 February 2008 03:37:22 pm Tom Lane wrote:
> johnf <[EMAIL PROTECTED]> writes:
> > Assume a standard install on Linux (what ever that means). Would a
> > normal user have access to information schema? I have a front end
> > written in python that acce
Assume a standard install on Linux (what ever that means). Would a normal
user have access to information schema? I have a front end written in python
that accesses tables and permissions are set based on roles. But I do
nothing with respect to the information schema view. I would like my pr
10 matches
Mail list logo
