Hi. Where would I locate information on setting up postgres as a stand
alone db for a gui application. I am writing this in python and have
been using sqlite but would like to try my app with postgres backend.
Links to any specific open source example would be helpful. The only
user would
in the normal way and then compiling the db adapter to work with
it.
Regards,
David
On Thursday, November 24, 2005, at 12:06 PM, Jaime Casanova wrote:
On 11/24/05, David Pratt [EMAIL PROTECTED] wrote:
Hi. Where would I locate information on setting up postgres as a
stand
alone db for a gui
How does one pass an array as a parameter to a plpgsql function? I
have tried this the following. I can't seem to get a select statement
to work without syntax problems and no examples in Postgres book to
help with this :( This is just a test so please ignore the fact it is
a simple
argh!!! It was telling me I had an error in select statement. Thanks
Tom!
Regards
David
On Wednesday, July 13, 2005, at 11:08 AM, Tom Lane wrote:
David Pratt [EMAIL PROTECTED] writes:
CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
DECLARE
test_array ALIAS
for select statement in the function and have function for insert in
table 2 return currval as well?
Regards,
David
On Tuesday, July 12, 2005, at 12:08 PM, Bruno Wolff III wrote:
On Sun, Jul 10, 2005 at 15:05:30 -0300,
David Pratt [EMAIL PROTECTED] wrote:
Hi Roman. Many thanks for your
Hi Roman. Many thanks for your reply. This is interesting and will I
give this a try and let you know how it works out. With this you are
right, application logic and transaction don't have to be separate
which would be nice for this. I was thinking the only way to solve was
a function that
Hi. I have a form that collects information from the user but then I
need to update three separate tables from what the user has submitted.
I could do this with application logic but I would feel it would be
best handled in Postgres as a transaction.
I need to do things in this order to
Hilbert wrote:
On Mon, Jul 04, 2005 at 03:27:59PM -0300, David Pratt wrote:
I am also going to look at Karsten's material shortly to see how his
system works
I am still away from the net but here is how to find the
description in our Wiki:
Go to user support, user guide, scroll down do
Hi. I am using array_dims to give me dimensions of multidimensional
array ie:
[1:5][1:2]
In my function I want to retreive the value of the second number from
array_dims (5 in example above)
This is what I am trying:
count_str = substr(dimensions from '\[\d\:(\d+)\]\[\d\:\d\]')
(this
Hi Tom. I misread the manual. I thought I could not do array_upper on
multidimensional array but it was specific concatenation functions.
Thank you for clarifying this.
Regards,
David
On Tuesday, July 5, 2005, at 01:22 PM, Tom Lane wrote:
David Pratt [EMAIL PROTECTED] writes:
Hi. I am
Many thanks, Karsten. I am going to look at your example closely.
Regards
David
On Sunday, July 3, 2005, at 09:50 AM, Karsten Hilbert wrote:
On Sat, Jul 02, 2005 at 05:00:50PM -0300, David Pratt wrote:
http://savannah.gnu.org/cgi-bin/viewcvs/gnumed/gnumed/gnumed/server/
sql/gmI18N.sql?rev
I figured out my trigger trouble:
SET lang_code_and_text = r.lang_code_and_text || ARRAY[new.iso_id,
default_text]
Above was not casting ARRAY[] as text[] so it would not concatenate
with existing array - so had to set a variable to cast the type and
then concatenate it to original and
Hi Greg. Not sure about this one since I have never made my own type.
Do you mean like an ip to country type of situation to guess locale?
If so, I am using a ip to country table to lookup ip from request and
get the country so language can be passed automatically to display
proper language
Basically I want this trigger to work after a language record in my
languages table is added.
CREATE TRIGGER language_add_trig AFTER INSERT ON languages
FOR EACH ROW EXECUTE PROCEDURE trigger_language_add();
Here is my function but it is not working. I am wanting to loop for
each
Many thanks Karsten for some insight into how you are handling this.
Regards,
David
On Saturday, July 2, 2005, at 06:08 AM, Karsten Hilbert wrote:
SELECT language_text[1][1] AS language_code,
language[1][2] AS text
FROM language_text;
They way we do that in GNUmed:
select lookup_val,
Hi Greg. Well I'm kind of half way but I think what I am doing could
work out.
I have an iso_languages table, a languages table for languages used
and a multi_language table
for storing values of my text fields. I choose my language from
iso_languages. Any table that needs a
idea! Even if the array gets larger it is not a big
issue since postgres can easily handle it.
Regards,
David
On Friday, June 17, 2005, at 12:15 AM, Greg Stark wrote:
David Pratt [EMAIL PROTECTED] writes:
I just want to get this right because it will be an important part of
what I am
Hi Steve. I have been a bit puzzling over a similar issue - not i18
for interface but for text data and trying to sort out a solution so I
will be interested to hear additional advice as well. When I wrote to
the list a couple of weeks back (look for my posting around the 17th) I
was looking
I am interested in having some internationalization capability to an
application. i18 will take care of the interface but not the data. To
internationalize the data, I am wanting to put the internationalized
text strings in a multi_language table like this:
CREATE TABLE multi_language (
19 matches
Mail list logo
