Thomas Kellerer writes:
> I always wonder whether it's more efficient to aggregate this path
> using an array rather than a varchar. Mainly because representing the
> numbers as varchars will require more memory than as integer, but then
> I don't know the overhead of an array structure and wheth
"drum.lu...@gmail.com" writes:
> So, the new plan is:
>
> 1 - Select 50.000 rows and gives it a batch number.
> 2 - Select *MORE* 50,000 rows and gives it a *NEW* batch number.
> 3 - Select *MORE* 50,000 rows and gives it a *NEW* batch number.
Why so complicated? Here's a simplified example:
Ben Leslie writes:
> "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL"
>
> I wanted to clarify if that was, technically, true.
Yes, but see below.
> "identifying a set of columns as primary key also provides metadata
> about the design of the schema, as a primary key imp
>From the 9.5 docs:
log_min_duration_statement (integer)
Causes the duration of each completed statement to be logged if the
statement ran for at least the specified number of
milliseconds. Setting this to zero prints all statement
durations. Minus-one (the default) disables logging sta
Johannes writes:
>> What the reason to execute all statements which return different
>> columns at once?
>>
>>> Saving roundtrips,
>>
>> In most cases they are not so big. Getting a bunch of duplicated data
>> is wasting you network bandwidth and don't increase speed.
>
> In my and your example
In article <[EMAIL PROTECTED]>,
Richard Huxton <[EMAIL PROTECTED]> writes:
>> $the_sql = " SELECT projectname, username, sum(hours)";
>> $the_sql .= " FROM timerecs";
>> $the_sql .= " WHERE projectname = projects.projectname ";
>> $the_sql .= " AND projectname = restrictions.projectname";
>> $the
In article <[EMAIL PROTECTED]>,
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am Wed, dem 24.10.2007, um 15:08:51 +0200 mailte Stefan Schwarzer folgendes:
>> Now, I want to enable queries which display national as well as
>> regional values. I could probably work with independent queries, but
In article <[EMAIL PROTECTED]>,
"Tom Allison" <[EMAIL PROTECTED]> writes:
> I am planning on doing a LOT of work with ip addresses and thought that the
> inet data type would be a great place to start.
Forget inet. Check out http://pgfoundry.org/projects/ip4r/ and be happy.
---
In article <[EMAIL PROTECTED]>,
Richard Huxton <[EMAIL PROTECTED]> writes:
> Kathy Lo wrote:
>> On 11/21/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
>>> You probably shouldn't attach any meaning to the numbers from a sequence
>>> - they're just guaranteed to be unique, nothing else.
> What you
In article <[EMAIL PROTECTED]>,
Chris Browne <[EMAIL PROTECTED]> writes:
> There may be a further optimization to be had by doing a
> per-statement trigger that counts the number of INSERTs/DELETEs done,
> so that inserting 30 tuples (in the table being tracked) leads to
> adding a single tuple wi
In article <[EMAIL PROTECTED]>,
Phil Rhoades <[EMAIL PROTECTED]> writes:
> People,
>> select count(*) as cnt, name from tst group by name having count(*) = 1
> This worked for my basic example but not for my actual problem - I get
> "column comment must appear in the GROUP BY clause or be used i
In article <[EMAIL PROTECTED]>,
Rainer Bauer <[EMAIL PROTECTED]> writes:
> Hopefully it won't be down for too long as I use a newsreader to read
> the lists.
I use www.gmane.org for that.
---(end of broadcast)---
TIP 9: In versions below 8.0, the
In article <4cba2bc4.9030...@darrenduncan.net>,
Darren Duncan writes:
> I would further recommend turning the above into a separate data type,
> especially if you'd otherwise be using that constraint in several
> places, like this ...
FWIW, the shatypes contrib package includes a binary md5 data
In article <20101022161331.gd9...@frohike.homeunix.org>,
Peter Bex writes:
> As far as I can see, this would imply either creating views on the
> for every user (or company?), or manually crafting queries
> to do the same.
Not necessarily. Consider this:
CREATE TABLE t1 (
id serial NOT N
I've found an incompatibility between PostgreSQL 8.2.4 and 8.3.0 which
is not clearly documented. Here's a short example:
CREATE TABLE t1 (
id CHAR(5) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO t1 (id) VALUES ('t1id1');
INSERT INTO t1 (id) VALUES ('t1id2');
INSERT INTO t1 (id) V
In article <[EMAIL PROTECTED]>,
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Thu, 7 Feb 2008, Harald Fuchs wrote:
>> This works fine in 8.2.4, but 8.3.0 rejects the ALTER TABLE with the
>> following (somewhat misleading) error message:
>>
>> ERROR:
In article <[EMAIL PROTECTED]>,
"Shoaib Mir" <[EMAIL PROTECTED]> writes:
> On Fri, Feb 15, 2008 at 6:13 PM, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> Thanks. But I had installed from rpm. Can I just download that .so
> file and put in the lib folder for pgsql and then start using it?
In article <[EMAIL PROTECTED]>,
Alban Hertroys <[EMAIL PROTECTED]> writes:
>> I'm thinking of something like the trick of surrounding C code with
>> pairs of #if 0 and #endif, which effectively comments out code,
>> even when it contains /* C-style comments */.
>>
>> Is there some similar trick f
In article <[EMAIL PROTECTED]>,
Tom Lane <[EMAIL PROTECTED]> writes:
>> I note that we can continue to have the current executables stashed in
>> PREFIX/share/libexec and let the "pg" executable exec them.
> Not share/ surely, since these are executables, but yeah.
> This brings me to the idea t
In article <[EMAIL PROTECTED]>,
"Rodrigo E. De León Plicet" <[EMAIL PROTECTED]> writes:
> On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey <[EMAIL PROTECTED]> wrote:
>> ... I have no idea how it could be fixed.
> - CREATE INDEX xifoo ON foo(bar_id);
> - ANALYZE;
> - Retry.
A compound index
CREATE
In article <[EMAIL PROTECTED]>,
"Andrus" <[EMAIL PROTECTED]> writes:
> I have table
> create Document ( docdate date, docorder integer )
> I need update docorder column with numbers 1,2 in docdate date order
> Something like
> i = 1;
> UPDATE Document SET docorder = i++
> ORDER BY docdate;
>
I think there's something sub-optimal with generate_series.
In the following, "documents" is a table with more than 12 rows,
vacuumed and analyzed before the queries.
EXPLAIN ANALYZE
SELECT count (d.id), floor (s.val / 5000)
FROM generate_series (1::INT, 5009) AS s (val)
LEFT JOIN docu
In article <[EMAIL PROTECTED]>,
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On Mon, Apr 14, 2008 at 5:21 AM, Harald Fuchs <[EMAIL PROTECTED]> wrote:
>> I think there's something sub-optimal with generate_series.
>> In the following, &
In article ,
aryoo writes:
> Dear list,
> In reference to the message below posted on the 'pgsql-hackers' list regarding
> 'iterative' queries,
> could anyone help me write the queries that return all full and all partial
> paths from the root?
Probably you want to use the following query:
WI
In article <4a425379.90...@alteeve.com>,
Madison Kelly writes:
> SELECT
> a.tbl1_name,
> b.tbl2_date,
> c.tbl3_value AS some_value
> FROM
> table_1 a
> LEFT JOIN
> table_2 b ON (a.tbl1_id=b.tbl2_tbl1_id)
> LEFT JOIN
> table_3 c ON (a.tbl1_id=c.tbl3_tbl1_id)
> W
In article <4a77c4af.2060...@gmx.de>,
Andreas Kalsch writes:
> To be completely
> in context of a schema - so that I can use all tables without the
> prefix - I have to reset the search_path very often.
Why? Just say "ALTER DATABASE foo SET search_path = public, bar, baz"
once and you're done.
In article <20090816122526.gw5...@samason.me.uk>,
Sam Mason writes:
> I've just had a look and PG does actually seem to be returning values as
> I'd expect, i.e. 0 <= n < 1.
That's what everyone would expect. If it's really implemented like
that the documentation is wrong, isn't it?
--
Sent
In article <20090820065819.ga2...@gheift.kawo1.rwth-aachen.de>,
Gerhard Heift writes:
> Hello,
> I try to create an unique index for a (time)period, and my goal is to
> prevent two overlapping periods in a row.
> ...
> Is there another solution to solve my problem?
Have a look at http://pgfoun
In article ,
Alban Hertroys writes:
> An example of the two sets I need to "join" are, at the left hand side:
> unit | token | exponent
> ---+---+--
> m.s^-1 | m | 1
> m.s^-1 | s | -1
> m.s^-2 | m | 1
> m.s^-2 | s | -2
> And at the right hand side:
> token | ex
In article <1257149236.3426.9.ca...@localhost>,
Vasiliy G Tolstov writes:
> Hello.
> I have table with cidr data type column (table is white/black list of
> networks).
> Does it possible to query - is the some address contains in any cidr
> network in this table? (for all networks in the table
In article <20110413163120.gu24...@shinkuro.com>,
Andrew Sullivan writes:
> On Wed, Apr 13, 2011 at 09:21:20AM -0700, Gauthier, Dave wrote:
>> Is there a way to add a default value definition to an existing column?
>> Something like an "alter table... alter column... default 'foo'".
> ALTER TA
In article <4e116e11.1030...@gmail.com>,
Daron Ryan writes:
> Hello David,
> This is a simplified version of my own attempt:
> SELECT *
> FROM ("oxford", "webster")
> WHERE NOT ( columnName = ANY (SELECT name FROM dictionaries))
> The idea is that "oxford" and "webster" come from the Java progr
In article ,
Marti Raudsepp writes:
> Hi,
> On Tue, Jul 5, 2011 at 09:50, Yan Cheng CHEOK wrote:
>> The essential difference between inet and cidr data types is that inet
>> accepts values with nonzero bits to the right of the netmask, whereas cidr
>> does not.
> Say, if you have a /8 netmask
In article <1312401318.5199.yahoomailclas...@web120108.mail.ne1.yahoo.com>,
Ioana Danes writes:
> Hi,
> I am planning to use the contrib module hstore
> but I would like to install it on a separate schema, not public,
> and include the schema in the search_path.
> Do you know if there are any
In article ,
Lauri Kajan writes:
> I have also tried:
> select
> *, getAttributes(a.id)
> from
> myTable a
> That works almost. I'll get all the fields from myTable, but only a
> one field from my function type of attributes.
> myTable.id | myTable.name | getAttributes
> integer | charact
In article ,
Antonio Vieiro writes:
> Hi all,
> One of my entities 'E' may be 'tagged' with an arbitrary set of 256 tags 'T'.
> A first approach could be to add a M:N relationship between 'E' and 'T'.
> A second way to do this could be to add a BIT(256) datatype to 'E',
> setting bits to '1' if
I think I've found a bug either in PostgreSQL 9.1.0 or in the ip4r
package (version 1.05). Since the problematic behavior occurs on
different tables and on different servers, it should be relatively easy
to reproduce:
CREATE TABLE foo (
id serial NOT NULL,
range ip4r NOT NULL,
PRIMARY KEY (
In article <21641.1316159...@sss.pgh.pa.us>,
Tom Lane writes:
> Harald Fuchs writes:
>> I think I've found a bug either in PostgreSQL 9.1.0 or in the ip4r
>> package (version 1.05).
> Good catch --- gistendscan is forgetting to free so->giststate.
Confirmed
In article ,
Matthew Hawn writes:
> I have a table with privileged data that is restricted using column level
> permissions. I would like to have single query that returns data from
> the table. If the user has permission, it should return the data but
> return NULL if the user does not have p
In article
,
Pavel Stehule writes:
> 2011/9/25 pasman pasmański :
>> I found second use case. Look at expression:
>>
>> where left(str,n)='value'
>>
>> function left(str,n) increase monotonically for str and n. With this
>> feature it can use index on str.
>>
>> Classic index needs recreating
In article ,
Marti Raudsepp writes:
> Ah, the reverse() function is not included with PostgreSQL 9.0 yet.
> This is what I use:
> CREATE FUNCTION reverse(input text) RETURNS text
> LANGUAGE plpgsql IMMUTABLE STRICT AS $$
> DECLARE
> result text = '';
> i int;
> BEGIN
> FOR i IN 1..length(i
In article <4116.1317226...@sss.pgh.pa.us>,
Tom Lane writes:
> Not sure this specific proposal makes any sense at all. IMO the only
> real advantage that rules have over triggers is that they work on a
> set-operation basis not a tuple-by-tuple basis.
Isn't that what statement-level triggers ar
In article <59670b22-30cb-4e6e-83c8-c1d1036c9...@solfertje.student.utwente.nl>,
Alban Hertroys writes:
> 2). Drop the ltree column and go with a truly recursive approach, something
> like this:
> CREATE TABLE node (
> categorytextNOT NULL PRIMARY KEY,
> sort_order i
In article <1f96e061-713c-4929-a7d9-278e5b608...@solfertje.student.utwente.nl>,
Alban Hertroys writes:
> On 20 Apr 2010, at 18:05, Harald Fuchs wrote:
>> Here's a working version:
>>
>> WITH RECURSIVE tree (path, category, sort_order, parent) AS (
>> SELEC
In article <4c0f4ba8.3040...@gmail.com>,
Ognjen Blagojevic writes:
> Plenty of solutions here:
> http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/
This doesn't mention the incredibly powerful windowing functions of
PostgreSQL >= 8.4.0:
SELECT username,
In article <20100719162547.ga17...@localhost>,
arno writes:
> Thanks, that's exactly what I was looking for.
No, I'd say you're looking for the ip4r package which provides
an indexable IP address range type.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
In article ,
Marcelo de Moraes Serpa writes:
> Some good souls hinted me at the prefix extension, but
> how would I use it?
Like this:
CREATE TABLE users (
id serial NOT NULL,
name text NOT NULL,
reversed_domain prefix_range NULL,
PRIMARY KEY (id)
);
CREATE INDEX users_dom_ix ON users
In article <[EMAIL PROTECTED]>,
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> or maybe not and I'm just not getting it.
> So here's the scenario:
> I have 3 tables
> forum: with primary key "id"
> forum_thread: again primary key "id" and a foreign key "forum_id" referencing
> th primary key
In article <[EMAIL PROTECTED]>,
Greg Smith <[EMAIL PROTECTED]> writes:
> On Tue, 9 Sep 2008, Artacus wrote:
>> Can psql access environmental variables or command line params?
> $ cat test.sql
> select :TEST as "input";
> $ psql -v TEST=16 -f test.sql
> input
> ---
> 16
> (1 row)
Nice tr
In article <[EMAIL PROTECTED]>,
"Andrus" <[EMAIL PROTECTED]> writes:
> I found that following query works:
> create temp table test ( test int ) on commit drop;
> insert into test values(1);
> select * from test where test = ANY ( '{1,2}' );
> Is this best solution ?
> Will it work without causi
In article <[EMAIL PROTECTED]>,
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am Tue, dem 14.10.2008, um 8:33:21 +0200 mailte Luca Ferrari folgendes:
>> Hi all,
>> I've got a query with a long (>50) list of ORs, like the following:
>>
>> SELECT colB, colC FROM table WHERE colA=X OR colA=Y OR co
In article <[EMAIL PROTECTED]>,
Ludwig Kniprath <[EMAIL PROTECTED]> writes:
> Dear list,
> I have to solve a simple Problem, explained below with some sample-Data.
> A typical M:N-constellation, rivers in one table, communities in the
> other table, m:n-join-informations (which river is running i
In article <[EMAIL PROTECTED]>,
Brian714 <[EMAIL PROTECTED]> writes:
> Currently, the database contains thousands of records in the Customers and
> Creditcards tables. I would like to re-define the Customers table to follow
> the following schema:
> Customers Table
> id:integer -- primary key
> f
In article <[EMAIL PROTECTED]>,
Michelle Konzack <[EMAIL PROTECTED]> writes:
> Hallo Harald,
> Am 2008-11-03 13:41:52, schrieb Harald Fuchs:
>> In article <[EMAIL PROTECTED]>,
>> Brian714 <[EMAIL PROTECTED]> writes:
>> > Customers Table
>&g
In article <[EMAIL PROTECTED]>,
Carson Farmer <[EMAIL PROTECTED]> writes:
> date | user
> --+-
> 20050201 | Bill
> 20050210 | Steve
> 20050224 | Sally
> 20050311 | Martha
> 20050316 | Ryan
> 20050322 |
In article <5a9699850911222009j272071fbi1dd0c40dfdf62...@mail.gmail.com>,
Brian Modra writes:
> 2009/11/23 Bino Oetomo :
>> Dear All
>>
>> Suppose I created a database with single table like this :
>> --start--
>> CREATE DATABASE bino;
>> CREATE TABLE myrecords(record text);
>> -
In article <4b0bbc8e.6010...@indoakses-online.com>,
Bino Oetomo writes:
> I downloaded pgfoundry's prefix, postgresql-8.3-prefix_1.0.0-1_i386.deb
> I install it using dpkg , and run the prefix.sql
> Create database .. named 'prefbino', and
> CREATE TABLE myrecords (
> record prefix_range NOT N
In article <87tywid19x@hi-media-techno.com>,
Dimitri Fontaine writes:
> The BTree opclass is not made to resist to overlapping data. Maybe in
> this case though we could say that 12 contains less elements than 1 so
> it's less than 1. Here's a test to redefine the pr_cmp() operator in
> term
In article <13289.1260290...@sss.pgh.pa.us>,
Tom Lane writes:
> Julian Mehnle writes:
>> So far, so good. However, can someone please explain the following to me?
>> wisu-dev=# SELECT regexp_matches('q...@foo@bar.zip', '([...@.]|[...@.]+)+',
>> 'g');
>> wisu-dev=# SELECT regexp_matches('q...@f
In article <4b5702b9.50...@postnewspapers.com.au>,
Craig Ringer writes:
>> What'd be the behavior of a (plpgsql) trigger function when called as
>> a statement level trigger?
>> Let's say that a statement will involve more than one row.
>> The documentation (v8.4.2, "35.1. Overview of Trigger Beh
In article <4b72aeb3.4000...@selestial.com>,
Howard Cole writes:
> Is there an SQL function to determine the size of a large object?
I'm using a pgsql helper function for that:
CREATE FUNCTION lo_size(oid oid) RETURNS integer
LANGUAGE plpgsql
AS $$
DECLARE
fd int;
res i
In article <20100308213549.gb...@svana.org>,
Martijn van Oosterhout writes:
>> "subsequent ... will store a null value" would imply that deleted columns
>> will still take some place, while "the space will be reclaimed ..." would
>> suggest that new rows (insert or updates in mvcc) don't have t
I've got a problem with regexp_replace which I could reduce to the following:
CREATE FUNCTION digest(text, text) RETURNS bytea
LANGUAGE c IMMUTABLE STRICT
AS '$libdir/pgcrypto', 'pg_digest';
CREATE FUNCTION sha224enc(text) RETURNS text AS $$
BEGIN
RAISE WARNING 'arg=»%«', $1
In article <609bf3ce079445569fc0d047a5c81...@andrusnotebook>,
"Andrus" writes:
> Database column contains merge data in text column.
> Expressions are between << and >> separators.
> How to replace them with database values ?
> For example, code below should return:
> Hello Tom Lane!
> How to
In article ,
"Marc G. Fournier" writes:
> Has anyone either played with, or gotten to work, a plPgSQL function
> that would take: 192.168.1.1/24 and determine the start and end IP
> from that? Or even start IP + # of IPs in the subnet?
Just install ip4r from pgfoundry, and you'll never look bac
I have a DB (mydb) where one table (mytbl) contains a large object
column. The contents are managed by contrib/lo. This breaks when I
want to copy the DB to another host where the schema is already
present with some old contents: when I do
pg_dump -c mydb | psql -q -h otherhost mydb -f -
pg_
"Andrus" writes:
> David,
>>Regular Expressions are your friend here. If you do not know them you
> should learn them; though if you ask nicely someone may just provide you
> the solution you need.
>>Split-to-array and unnest may work as well.
>
> Thank you very much. I dona**t know regexps.
>
Jeff Amiel writes:
>> At the moment I think the only way to work around this is
>> to denormalize
>> your schema a bit.
> And I feared as much.
> It's biting me in other areas as well...this unusual distribution of
> data...certain types of customers have completely different data patterns
> t
Jay Levitt writes:
> * You want contextual queries.
>
> (I guess this is a special case of "you need non relational features".)
>
> In my case, I want all queries against content to be filtered by their
> relevance to the current user. That can't go into a view, because
> views don't have paramet
In article
<482e80323a35a54498b8b70ff2b8798003e5ac7...@azsmsx504.amr.corp.intel.com>,
"Gauthier, Dave" writes:
> I have a temp table containg wildcarded strings and I want to select values
> froma different table using ?like? against all those wildcarded values.
> Here?s
> the example...
> cr
In article <1233269836.13476.10.ca...@ubuntu>,
Mike Diehl writes:
> Hi all.
> I've encountered an SQL problem that I think is beyond my skills...
> I've got a table full of records relating to events (phone calls, in
> this case) and I need to find the largest number of events (calls)
> occurrin
In article <4989e659.3000...@computer.org>,
David Wall writes:
> If I have an "unlimited" number of name-value pairs that I'd like to
> get easy access to for flexible reports, could I store these in two
> arrays (one for name, the other for value) in a table so that if I had
> 10 name-value pair
In article <17050.1234200...@sss.pgh.pa.us>,
Tom Lane writes:
> Lee Hughes writes:
>> Hi, I need a function that accepts a table name and returns a 2-dimensional
>> array of the table data.
> Well, in 8.3 and up there are arrays of composite types, so you can
> do something like
>
In article <437faa9f-df2d-429e-9856-eb2026b55...@solfertje.student.utwente.nl>,
Alban Hertroys writes:
> On Mar 30, 2009, at 5:39 PM, A B wrote:
>> Hi,
>> In the next project I'm going to have a number of colums in my tables,
>> but I don't know how many, they change. They all use integers as
>>
In article <43639.216.185.71.24.1242834374.squir...@webmail.harte-lyne.ca>,
"James B. Byrne" writes:
> What I want to be able to do is to return the most recent rate for
> all unique rate-pairs, irrespective of type. I also have the
> requirement to return the 5 most recent rates for each rate-p
In article <[EMAIL PROTECTED]>,
"FERREIRA William (COFRAMI)" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION adoc.CREATE_XML_FILE(docId int4, eleId int4, evo
> int4, fileName text, fileRelativeDir text)
> RETURNS int4 AS
> $BODY$
> my $theClob='';
>
> my $params = 'select
> adoc.GET_
In article <[EMAIL PROTECTED]>,
"Rick Schumeyer" <[EMAIL PROTECTED]> writes:
> These results are for a single process populating a table with 934k rows,
> and then performing some selects. I also compared the effect of creating
> indexes on some of the columns.
> I have not yet done any testing
In article <[EMAIL PROTECTED]>,
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Mon, Mar 21, 2005 at 12:35:22AM -0600, Thomas F.O'Connell wrote:
>> The number of lines depends merely on where you place your line breaks.
>>
>> IF(days_complete <= 120, job_price, 0)AS Days_120
>>
>> could be written
In article <[EMAIL PROTECTED]>,
Alex Adriaanse <[EMAIL PROTECTED]> writes:
> I think that would greatly decrease the chances of a race condition
> occurring, but I don't think it'd solve it. What if 150 other
> revisions occur between a row update and its corresponding commit?
How about the foll
In article <[EMAIL PROTECTED]>,
"ON.KG" <[EMAIL PROTECTED]> writes:
> Hi
> Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> MySQL?
> or any other way to delay inserting?
Every INSERT in PostgreSQL is delayed in some sense: firstly, it is
not visible to anyone else until
In article <[EMAIL PROTECTED]>,
Alex Adriaanse <[EMAIL PROTECTED]> writes:
> Thanks for the input everyone. I think Harald's approach will work
> well...
I'm not so sure anymore :-(
Consider something like that:
UPDATE tbl SET col1 = 1 WHERE col2 = 1;
UPDATE tbl SET col1 = 2 WHERE col2 = 1;
w
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout writes:
> Perl uses reference counting, so as long as a string is visibile
> anywhere (remember closures), it stays around and disappears as soon as
> it's unreferenced.
> If you have large strings or arrays you don't need, maybe you need to
In article <[EMAIL PROTECTED]>,
Alex <[EMAIL PROTECTED]> writes:
> Hi,
> i am having a problem with a plperl function. bellow function always
> returns me an error saying "elements of Perl result array must be
> reference to hash"
> Can anyone point me out what i am doing wrong here?
> Basically
In article <[EMAIL PROTECTED]>,
"Relyea, Mike" <[EMAIL PROTECTED]> writes:
> I need to create my very first function. I'm using 8.0.2 and I need a
> function that I can call (from my client app) with an unknown number of
> criteria for a select query. The function will then return the results
>
I'm trying to find out which columns of which tables reference which
columns of which tables by querying the information_schema. I found
the referencing columns in key_column_usage and the referenced columns
in constraint_column_usage - fine so far.
Now consider the following:
CREATE TABLE t1
In article <[EMAIL PROTECTED]>,
Lyubomir Petrov <[EMAIL PROTECTED]> writes:
> create sequence seq_tmp;
> select nextval('seq_tmp') as rank, a.id, a.name from (select id, name
> from t order by name desc) a;
> drop sequence seq_tmp;
Using a temporary sequence for that would avoid naming conflicts.
In article <[EMAIL PROTECTED]>,
Rich Doughty <[EMAIL PROTECTED]> writes:
> On 17 May 2005, Hrishikesh Deshmukh wrote:
>> Hi All,
>>
>> Anybody knows how to use perl dbi to read a file line by line and
>> insert into db!
>> The books which i have tell you exclusively on running queries.
> it depe
In article <[EMAIL PROTECTED]>,
josue <[EMAIL PROTECTED]> writes:
> Hello list,
> I need to track down the missing check numbers in a serie, table
> contains a column for check numbers and series like this:
> dbalm=# select doc_numero,doc_ckseriesfk from bdocs where doc_cta=1
> dbalm-# and doc_t
In article <[EMAIL PROTECTED]>,
Simon Riggs <[EMAIL PROTECTED]> writes:
> If the WHERE clause said bdocs.doc_numero > 7 we would hope that this
> was applied before the join.
Stating this would change the OUTER into an INNER JOIN, and this would
imply that the order of the restrictions is irrelev
In article <[EMAIL PROTECTED]>,
Guy Doune <[EMAIL PROTECTED]> writes:
> Hi,
> I would know how to set the encoding (unicode, ASCII,
> etc.) for getting postgresql accepting my entry with
> accent an all the what the french poeple put over
> there caracter while they write...
French is covered bot
In article <[EMAIL PROTECTED]>,
Alex Turner <[EMAIL PROTECTED]> writes:
> 1. ( ) text/plain (*) text/html
> As sort of a side discussion - I have postulated that quoting all incomming
> numbers as string would be an effective defense against SQL Injection style
> attacks, as m
In article <[EMAIL PROTECTED]>,
Alex Turner <[EMAIL PROTECTED]> writes:
> delete * from user; > select * from table where my_id=$in_value > Am
> I just smoking crack here, or does this approach have some merit?
> The former :-) The correct defense against SQL injection is prope
In article <[EMAIL PROTECTED]>,
Douglas McNaught <[EMAIL PROTECTED]> writes:
> Rory Browne <[EMAIL PROTECTED]> writes:
>> select u.username, g.groupname from users u, groups g where u.group_id=g.id
>> (assuming users are in exactly one group)
>>
>> If the group_id field in the users table was cor
In article <[EMAIL PROTECTED]>,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> As a background, I'll be using Postgres in part as a processing queue
> for a 40-column stream of information (~ 250 bytes/row) with a
> sustained input rate of 20 rows/sec. This queue will be processed
> periodicall
In article <[EMAIL PROTECTED]>,
Alban Hertroys <[EMAIL PROTECTED]> writes:
> Andrus wrote:
>> In my current DBMS I can use
>>
>> create table t1 ( f1 int, f2 int );
>> create table t2 ( f3 int, f4 int );
>> update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
> That looks like a self-join
I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r).
Has anyone managed to fix that?
---(end of broadcast)---
TIP 6: explain analyze is your friend
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout writes:
> On Sat, Dec 09, 2006 at 12:10:16PM +0100, Harald Fuchs wrote:
>> I would like to upgrade to PostgreSQL 8.2.0, but there's one thing
>> stopping me: the need for ip4r (http://pgfoundry.org/projects/ip4r)
In article <[EMAIL PROTECTED]>,
Martijn van Oosterhout writes:
> Looking at CVS, line 967 is a blank line, so I have to ask what version
> you're compiling. I notice the CVS tree got some patches two months ago
> for 8.2 but there has been no release since then. Perhaps you should
> try the lates
In article <[EMAIL PROTECTED]>,
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> can anybody think of of a way to sneak these into dollar quoted
> strings for substitution into create function?
> would i would ideally like to do is (from inside psql shell)
> \set foo 500
> create function bar() r
In article <[EMAIL PROTECTED]>,
"Jim C." <[EMAIL PROTECTED]> writes:
> Maybe it is and maybe it isn't. I wouldn't know. I'm merely the
> unfortunate soul chosen to convert this from MySQL to Postgres. :-/
> I've been working on it for a week now. I've got to say that it pains me
> to know that
1 - 100 of 125 matches
Mail list logo
