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
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.
my text field contains:
'123,134,343,345'
I
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 our
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
attendid = 301
I need the pkid = 301
But there may or may
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.category,
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 and
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
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 accesses tables and permissions are set
10 matches
Mail list logo