ey DON'T support
> the postgres-specific "select nextval('seq_name')". Instead they gave
> me the hint to use the sql-conform "call nexval('seq_name')".
That statement is not any more SQL conforming than the other.
--
Peter Eisentraut
http://develo
Hi,
what about
SELECT controller_id FROM control
WHERE controller_id NOT IN
(SELECT DISTINCT controller_id FROM datapack);
?
Regards
Peter
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von
> Richard Broersma Jr
> Ges
On Saturday 06 June 2009 22:53:19 Isaac Dover wrote:
> Hello, I am attempting to build an xml representation of any database, but
> I'm having trouble doing so. I was interested in using the existing xml
> functions, such as "schema_to_xmlschema", but the results are strange and
> unusable. The res
...
--
Peter Headland
Architect - e.Reports
Actuate Corporation
On Wednesday 22 July 2009 19:16:21 David Weilers wrote:
> I have the following query:
>
> select v.id, array_to_string(array_accum(s.name),', ') as sector ,
> array_to_string(array_accum(p.name),', ') as provincie from tblvacature
> v, tblaccount a , tblvacaturesector vs, tblsector s ,
> tblvacatur
g like:
UPDATE (SELECT ... ) ...
--
Peter Headland
Architect
Actuate Corporation
>Assuming that there is a unique identifier on queue
Alas, there is not. The PK is made up of 4 columns.
--
Peter Headland
Architect
Actuate Corporation
-Original Message-
From: D'Arcy J.M. Cain [mailto:da...@druid.net]
Sent: Tuesday, August 11, 2009 03:25
To: Peter Headland
C
a new index) for
performance reasons.
Given that additional constraint, is my original plan using a loop to iterate
over a cursor reasonable? I don't anticipate p_number_of_items being more than
20.
--
Peter Headland
Architect
Actuate Corporation
-Original Message-
Fro
> Unfortunately, there is no single column that provides a unique id.
Correction - I did not understand what ctid was, but now I do, so I will try
your tip.
--
Peter Headland
Architect
Actuate Corporation
-Original Message-
From: Peter Headland
Sent: Tuesday, August 11, 2009 10
On mån, 2009-08-24 at 18:42 +0200, Denis BUCHER wrote:
> Question 1 :
> Is it the expected behavior ? These characters have a SQL_ASCII
> equivalent because I already have them stored in another table of the
> same database
SQL_ASCII is not the same as ASCII. SQL_ASCII means, take the bytes as
th
On Wed, 2009-09-30 at 22:14 -0700, Jyoti Seth wrote:
> I want to restore data of a single table. Before restoring the data I
> disabled all the triggers and constraints on that table. I used the restore
> command with --clean option so that data gets deleted from that table and
> then fresh data ge
oth of them in one query
using something akin to 'zvt%', like
select * from attachments where textsearchable @@ 'zvt%';
I've been unable to find anything in documentation. If there's
anything in tsearch2 that can do this and is faster than LIKE clauses
on full-text, tha
On Wed, Jul 7, 2010 at 5:44 PM, Oleg Bartunov wrote:
> it's called prefix search:
>
> =# select 'zvt123456'::tsvector @@ 'zvt:*';
> ?column? --
> t
Ah, that works. Excellent.
Thanks,
Peter
--
Sent via pgsql-sql mailing list (pgsql-sql
On mån, 2010-07-19 at 14:47 +0400, Dmitriy Igrishin wrote:
> For example, when using libpq(-xx), it is possible to get the oid of
> the type of any column.
> Is there a guarantee that oids of base types (void, integer, ... )
> will not change in future
> releases of Postgres?
There is no actual "g
of cast function must match or be binary-coercible
from source data type
Is there a way to tell Access to do the right thing, or is there a
better way to define the type/domain, or is there some better product
to use?
Thanks much,
Peter
P.S. In case people are interested in the specifics of the
On Wed, Aug 4, 2010 at 12:47 PM, Richard Broersma
wrote:
> On Wed, Aug 4, 2010 at 10:31 AM, Peter Koczan wrote:
>
>> One of the snags that's popped up is that there's some incompatibility
>> between data types. Specifically, many fields are the Sybase type
>> &
the stumbling block we're running into. ODBC and these
fields' assumptions of true/false are at odds. I'm trying a few other
things with casts in the meantime to see if they'll work.
Does anyone know if another product, like OpenOffice Base with its
native postgres drive
On tis, 2010-08-10 at 18:38 +0200, Imre Horvath wrote:
> Hi!
>
> I don't know if it's the right place or the psycopg2 list:
>
> I've got a plpython function, with a character varying param.
> I can call it from sql.
> But when i try to call it with psycopg2.callproc('testfunc', ['test']),
> i've
On tis, 2010-08-10 at 22:21 -0430, Jose Ildefonso Camargo Tolosa wrote:
> And it works, it gives me something like:
>
> product_id | name | code | manufacturer_id |
> manufacturer_name | num_serials
> +--+---+--
On Wed, Aug 4, 2010 at 8:49 PM, Richard Broersma
wrote:
> On Wed, Aug 4, 2010 at 3:41 PM, Peter Koczan wrote:
>
>> Yep, that's the stumbling block we're running into. ODBC and these
>> fields' assumptions of true/false are at odds. I'm trying a few other
&
d for such report will be just fine.
>
> Sorry for the lame question. I didn't find any clues on the web
> .(typically, I fail to phrase the right keywords)
>
> --
> Thanks.
>
> David Harel,
>
> ==
>
> Home office +972 77 7657645
> Cellular: +972 54 4534502
> Snail Mail: Amuka
> D.N Merom Hagalil
> 13802
> Israel
> Email: harel...@ergolight-sw.com
>
>
--
Peter Steinheuser
psteinheu...@myyearbook.com
On tor, 2010-11-25 at 14:42 +0900, Chang Chao wrote:
> How strings are sorted when LC_COLLATE = ja_JP.UTF-8.
> I tried to read the documention on that,but there are just a few
> words,
> like LC_COLLATE determines string sort order,
> Is there a specific reference about this?
> So I can implement a
psv_parent_master
> limit ...
>^
>HINT: No operator matches the given name and argument type(s).
> You
>might need to add explicit type casts.
>
>Thanks.
>
>
> --
> Sent via pgsql-sql mailing lis
I don't know what Postgres version you're using but check out the doc
related to String Functions and Operators.
Cheers,
Peter
On Tue, Dec 7, 2010 at 4:47 PM, Tony Capobianco
wrote:
> Ok, that worked. Why did I need to cast both as text though?
>
> plsql_dw=# se
magazinecategoryid, magazineid, categoryid)
>
> VALUES (4, 10, 4);
>
>
>
>
>
>
>
> INSERT INTO magazinecategory(
>
> magazinecategoryid, magazineid, categoryid)
>
> VALUES (5, 11, 4);
>
>
>
> INSERT INTO magazinecategory(
>
>
magazineid;
On Wed, Jan 19, 2011 at 3:11 PM, Carla wrote:
> 2011/1/11 Peter Steinheuser
>
>> Well, if yoi have PG 8.4 and above -
>>
>> select categoryid, magazineid from (
>> select row_number() over (partition by categoryid order by
>> categoryid,magazineid
al6);
>
> select c1, method(c2)
> group by c1
>
> returns:
>
> 1, "val1, val2, val3"
> 2, "val1"
> 3, "val5, val6"
>
>
> Thanks a lot!
>
> --
> Lu Ying
>
> --
> Sent via pgsql-sql mailing list (pgsql-sq
30 | 9
> 1950 | 10
> 7 | 11
>67 | 12
>
> Thanking you in advance for any help on this. The caffiene seems to be not
> working well today.
>
> Aaron
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Peter Steinheuser
psteinheu...@myyearbook.com
;t had much luck with the length or char_length functions on
> postgres.
>
> Thanks.
> Tony
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Peter Steinheuser
psteinheu...@myyearbook.com
y_test
> user_test
> timestamp_test
> role_t
> py_test
> money_test
> lock_test
> local_1
> lang_test
> interval_test
> foob
> fooa
> fldlength
> fk_1
> default_test
> csv_null
> check_two
> check_test
> array_test
> (29 rows
y easily,
so it made the most sense for me.
Also, Postgres 9.1 allows adding values to enum types, so you could
always use that when it is finally released.
Hope this helps,
Cheers,
Peter
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On ons, 2011-06-22 at 01:43 -0700, Samuel Gendler wrote:
> I seem to recall a thread here about it ignoring spaces entirely in that
> collation (and maybe ignoring capitalization, too?).
The way it works is that every collating element (letter or other
character or character group that you sort as
On ons, 2011-06-22 at 02:39 -0700, Samuel Gendler wrote:
> Pavel suggested using a collation of ucs_basic, but I get an error
> when I
> try that on linux:
>
> $ createdb -U u1 --lc-collate=ucs_basic -E UTF-8 test
> createdb: database creation failed: ERROR: invalid locale name ucs_basic
ucs_ba
On tor, 2011-06-23 at 05:57 +0200, Pavel Stehule wrote:
> 2011/6/22 Peter Eisentraut :
> > On ons, 2011-06-22 at 02:39 -0700, Samuel Gendler wrote:
> >> Pavel suggested using a collation of ucs_basic, but I get an error
> >> when I
> >> try that on linux:
>
On mån, 2011-11-07 at 08:44 +, Richard Huxton wrote:
> > myvarString = "long string that contains single quotes"
> > cusor.execute("insert into table (pkid, myfield) values (%s, $$%s
> $$)",(123,
> > myvarString))
> >
> > When I execute the above I'm seeing:
> > E'long string that contains sing
I have two columns in two distinct tables, one is the starting time of
an event, timestamp without time zone. Data is the utc datetime (for
sorting across time zones), the other is the number of minutes to add.
I am migrating from Firebird. One of the queries uses the dateadd
function to build
Bit more googling and I came up with:
r.utc + CAST( tz.diffmins || ' ' || 'minutes' AS interval)
It works, but is it the best way?
On 1/03/2012 6:50 AM, Peter Faulks wrote:
I have two columns in two distinct tables, one is the starting time of
an event, timestamp withou
hari.fu...@gmail.com wrote:
Peter Faulks writes:
I have two columns in two distinct tables, one is the starting time of
an event, timestamp without time zone. Data is the utc datetime (for
sorting across time zones), the other is the number of minutes to add.
Maybe I'm missing somethin
, if there's no good solution I'm happy to simply swallow the
exceptions, because I don't care (in this case) which of two competing
transactions gets to insert the row. However, if I am doing something
stupid I'd like to be put right!
Peter Harris
Software Engineer
HuzuTech Ltd.
It is 9.0.4 if that helps.
Is there some reason it should work differently on 9.1 or 8.x?
On 25 April 2012 13:29, Abbas wrote:
> Which version of postgresql it is ?
>
> Best Regards,
> Abbas
>
>
>
> On Wed, Apr 25, 2012 at 5:15 PM, Peter Harris
> wrote:
>
>&g
On lör, 2012-05-26 at 21:47 -0600, Wes James wrote:
> on the ascii table here:
>
> http://www.ascii-code.com/
>
> upper case letters should sort before lowercase letters.
ASCII has nothing to do with how letters "should" be sorted. It is not
a sorting standard, it is a character encoding standa
s at least for 7.4. I don't think it works for newer versions,
but it should give you an idea what is required to get it working.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you
so there were porting troubles, but I don't
remember the details. I'm just saying that it's doable if it's a
necessity for someone.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In ve
Scott Marlowe wrote:
> Would it be possible if we required postfix operators and related to
> be inside parens?
>
> select x ~~ y as yabba
> OR
> select (x ~~ y) yabba
That's pretty much what you get if you restrict the expression to
c_expr.
--
Peter Eisentraut
http://d
Aarni Ruuhimäki wrote:
> ' ... type double precision ... will be depreciated / unsupported in
> future releases ... '
That is completely false.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)
Hello,
First, sorry if this has already been covered, though I didn't find anything
similar in the archives. Also sorry if this is the wrong list for this type
of question, though it seemed to be the most relevant list for this question.
On to the question:
I'm writing a simple import script t
Hi Aaron,
I'm using PHP5 as the programming language.
Thanks,
Pete
On Thursday 02 November 2006 16:58, Aaron Bono wrote:
> On 11/2/06, Peter Hanson <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > First, sorry if this has already been covered, though I didn't
ng
> all of the fields if I add columns to the table (whatever).
>
> Is this an SQL thing or a PostGreSQL thing?
SQL
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you se
s done. Is there a link or book that explains the basics of how a
database parses SQL and how it then operates on the data?
Thank you,
Peter
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
this automatically. Which is kind of useful.
5. You can do this manually via cron or by hand if you wish.
Peter.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
solve this very
simple problem quikly... :-(
thanks
Ivan
select * from t1 full join t2 on (t1.id=t2.id);
you'll end up with the id column from both tables if you don't want
that you are going to need to list all the column names.
Peter.
---
Hello,
How can I loop a PL/PgSQL recorset variable? The example:
DECLARE
v_tmp_regi RECORD;
v_tmp RECORD;
BEGIN
SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE
sf.termekfajta_id=
a_termekfajta_id AND sf.marka_id=a_marka_id;
DELETE FROM sulyozas_fu
ertainly allowed by PostgreSQL
without any flags. It's just that the result is not what some people
expect.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Am Mittwoch, 28. Februar 2007 14:02 schrieb Ezequias Rodrigues da Rocha:
> it is possible to use case with character (1) ?
Have you tried it?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You
n bring up
> Q3C since it's less widely deployed.
How do you manage to get your own code installed under that theory?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support the Pos
Claus Guttesen wrote:
> Why does select and select(count) produce two different results?
count(expression) only counts nonnull values.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't
e the access simpler.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
llowed in check constraints.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
REATE FUNCTION foo (a int) RETURNS void
LANGUAGE sql
AS $$ SELECT foo($1, default-value); $$;
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 4: Have you searched our list arc
OR UPDATE.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Am Mittwoch, 4. April 2007 14:36 schrieb [EMAIL PROTECTED]:
> It is possible to retrieve information about the server hardware via
> postgreSQL ?
You'd have to write your own function.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end o
able, values ((1,3),(2,2),(3,5),(4,1),(5,4)) as values
where values.id=table.second order by values.first;
never done it but I think it should work with a bit of playing arond...
Peter.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hello,
I was wondering if there's a fast way I can add "on delete cascade" to all
foreign key constraints in my database? Maybe a quick update I can make
against the catalog possibly? Or is there a way I can query for all foreign
key constrains in the database and then I could write up a quick
of this is strictly speaking incorrect anyway. And the queries that do
work will most likely start not working in a future version. All of this is
a gradual effort to reduce excessive automatic type casting.
I suggest you fix your application.
--
Peter Eisentraut
http://developer.postgresql
Is there a way to query the database system identifier that pg_controldata
outputs from SQL?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Is there a way to query the database system identifier that
> > pg_controldata outputs from SQL?
>
> Don't think so. Do you have a use-case for providing a function to
> return that?
I'd
ld build a view of all the sub tables and then select by
tablename='whatever'
You may also want to look into inheritance
Only some ideas
Peter.
hould use the cache feature of a sequence is there
just for this purpose.
That way when you get the next value your session caches and any other
sessions will get one after your cache range.
Peter
her roles, but not have other
> SUPERUSER priveleges - how can I do that?
See CREATEROLE privilege.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore yo
not three... You may want to use views to
simplify things.
Peter Childs
Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> ---
Am Dienstag, 20. November 2007 schrieb Andreas Joseph Krogh:
> Is it considered "safe" to use 8.1's pg_dump to dump an 8.2-db and load it
> into 8.1?
No, pg_dump will complain if you try that. It could work, with manual fixups
perhaps, but it is far from "safe&qu
o-use than SQL. I've been
wondering ever since why the worse so often gets the upper-hand over
the better. (I am obviously having a hard time "growing-up" :-) )
Cheers,
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the
ata in the
table only the speed and security or the table so foreign keys don't really
fit in this class nor do unique indexes.
Peter.
ion_schema.columns WHERE
column_name LIKE '%name%';
Add DISTINCT and other columns to taste.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 6: explain analyze is your friend
can be made to present the same SQL-level API as we have for
> OSSP. Otherwise we'll be faced with boatloads of platform-dependent
> client code ...
Indeed. Linux, for example, also has "its own" UUID generator, but I
intentionally used the OSSP library, because it is platfo
ForwardOnly, adLockReadOnly' then it work fine. However,
> I need to use this query for make data ready to be updated on some record.
> How can I fix this problem?
8.3 supports updatable cursors. Try that.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
--
upport that setup.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Emi Lu wrote:
> Can someone suggestion some tutorial/hyperlinks/docs about how
> postgresql output query results into xml files?
http://www.postgresql.org/docs/8.3/static/functions-xml.html#FUNCTIONS-XML-MAPPING
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your
ttle client code as
possible. Is it possible to automatically change the output like this,
preferably on a per-connection basis? I found stuff regarding the
datestyle parameter in the docs, but that doesn't quite do what I'd
like.
Thanks much,
Peter
--
Sent via pgsql-sql mailing l
some code that actually somewhat depends on this format,
> > and one of my goals in this port is to change as little client code as
> > possible. Is it possible to automatically change the output like this,
> > preferably on a per-connection basis? I found stuff regarding the
> > datestyle parameter in the docs, but that doesn't quite do what I'd
> > like.
> >
> > Thanks much,
> > Peter
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
---
select * from pg_catalog.pg_timezone_abbrevs where abbrev = 'GMT';
abbrev | utc_offset | is_dst
++
GMT| 00:00:00 | f
(1 row)
--
The database version is 8.3.0.
Any help appreciated,
Peter
--
Sent via pgsql-sql mailing list (pgsql-sql
Thank you, Andreas! Your advice is very useful to me.
I would still be interested why "TZ" is not accepted in the format string.
Thanks
Peter
On Fri, Jun 20, 2008 at 8:15 AM, A. Kretschmer
<[EMAIL PROTECTED]> wrote:
> am Fri, dem 20.06.2008, um 7:51:50 +0200 mailte Pet
reason for this
limitation or is it just the implementation waiting to be completed
(nobody has had an itch intensive enough to scratch it)?
Thanks
Peter
On Fri, Jun 20, 2008 at 8:50 AM, A. Kretschmer
<[EMAIL PROTECTED]> wrote:
> am Fri, dem 20.06.2008, um 8:35:10 +0200 mailte Peter K
Am Donnerstag, 3. Juli 2008 schrieb Isaac Dover:
> select
> XmlElement(name "Catalog",
> XmlElement(name "Tables",
> XmlAgg(XmlElement(name "Table", XmlAttributes(T.table_name as
> "Name"), XmlElement(name "Columns",
> -- i was attempting to aggregate here as well
> (select XmlE
James Neethling wrote:
I want to add uuid support to a postgres 8.1 installation. Can I install
8.3 uuid-contrib into 8.1?
8.1 does not have a uuid type, so this won't work.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresq
Ruben Gouveia wrote:
What is the difference between these two. I know that max() is an
aggregate function
... and greatest() is a normal single-row function.
One works vertically, one works horizontally, if that helps you. :-)
Or max() is like sum() and greatest is like +.
--
Sent via pgsql
Nacef LABIDI wrote:
I want to perform an intersection between several select queries but
without using the INTERSECT keyword.
select userid from orders where productid=1 INTERSECT select userid from
orders where productid=2
I want to transform it without the INTERSECT.
(select userid from
Bart van Houdt wrote:
Oracle has a nice package procedure (dbms_output.put_line) to display a
message in SQL*Plus, which can display a message to the user. I use this
a lot, to notify users of the progress being made during the execution
of a script.
Is there a way to do this with Postgres as
On Tuesday 13 January 2009 18:56:33 Brad Balmer wrote:
> Why would the following not work?
> create index tstTbl_idx on test_tbl (cast(xpath ('//uim:upcCode/text()',
> job) as text[]));
Looks like you are missing a namespace definition.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.or
/include/miscadmin.h - Define your new datestyle.
src/bin/psql/tab-complete.c - Not necessary to add it, but having it
in the list of tab completions for datestyle is nice.
I don't use the ecpg interface, so I didn't bother patching that. It
seems like it would be analogous to what'
On Thursday 12 March 2009 19:28:19 Duffer Do wrote:
> I want to return the following:
> locations | number_visits
> Frankfurt | 6
> Manhattan | 3
> Talahassee | 0
>
> My query only returns:
> Frankfurt | 6
> Manhattan | 3
> My query:
> SELECT count(user_name) as number_visits, loca
orrect one?
If per vertex format is the correct one, do I need to
'close' the path by entering the first vertex again at the end of the
list?
ie:
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Cx,Cy),(Ax,Ay)) );
Thanks,
Peter
--
Sent via pgsql-sql mai
Hello,
I am having a problem with a FUNCTION.
The function creates just fine with no errors.
However, when I call the function postgres produces an error.
Perhaps someone can enlighten me.
--I can reproduce the error by making a test function
--that is much easier to follow that the original:
Adrian Klaver wrote:
On Wednesday 01 April 2009 4:31:20 pm Peter Willis wrote:
Hello,
I am having a problem with a FUNCTION.
The function creates just fine with no errors.
However, when I call the function postgres produces an error.
Perhaps someone can enlighten me.
--I can reproduce the
lines before the FOR loop...
I think I need to go back and approach the function from a
different direction.
Thanks for all the pointers.
Peter
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
'RECORD'.
(The lights come on...)
And here I thought it would all be so simple.
You show a valid, and most informative solution.
This should get things working for me.
Thank you very much for your help.
Peter
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make chang
(terribly ugly) my select statements to
generate a single SQL query from all. This allows
me to change the output of the query without needing
to define a new set of output 'OUT' parameters each time
I change things.
I have use of the 'OUT' parameters with another set
of functi
. It's fine if the answer is no, I'm just curious if I should
pursue this path or look for a different one. And if there's a way to
do this or something like it besides "create scripts in
Perl/Python/etc." that you know of, I'd appreciate any information.
e statements would very quickly become
unmaintainable. Wrapper scripts are probably the way to go for me.
Thanks again,
Peter
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
On Wednesday 08 April 2009 20:08:55 Mario Splivalo wrote:
> What are your practices, when do you use ENUMs and when Domains?
When given the choice, pretty much ENUMs. Domains weren't really conceived
for this sort of thing in the first place, so it's good to move away from
them.
--
Sent via p
301 - 400 of 434 matches
Mail list logo
