On 09/03/2008 22:33, Reid Thompson wrote:
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults to connecting to the local machine unless you tell it
otherwise, so this is
hi,all.
i want some advice about ideas for gsoc. i don't konw if it is appropriate
that i send a email here, so if you feel uncomfortable, please accept my
apology.
1.release8.2 make COPY TO can copy the output of an arbitrary SELECT
statement. so i think maybe COPY FROM can get data from output
Hi all,
I am having a stored function in plperlU which is called from php script then.
It select data from a table, export them to a file and zips the file. The
problem is that it should store this file into temporary table. Then it should
return some identificator to php, so that the user can d
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
> On 09/03/2008 15:34, Reid Thompson wrote:
>
> > you'll also probably have to add the parameter -h 127.0.0.1
>
> psql defaults to connecting to the local machine unless you tell it
> otherwise, so this is redundant; though it certainl
I was trying to extract XML fragments within a pl/pgsql function by nested
xpath() function calls, and found that when namespaces are used in the
XML, only the first xpath() call is able to correctly use namespaces.
First here is an example that works, when no namespaces are used:
BEGIN;
CREATE T
On Mar 8, 4:46 pm, [EMAIL PROTECTED] (hubert depesz lubaczewski)
wrote:
>
> you might find this
> useful:http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-s...
>
> please also read comments.
>
> depesz
>
This is very helpful. It sees that there's a way to do it without
hacking
Webb Sprague wrote:
I haven't tested but this is what I would do (uses arrays, which are
handy when you need them), with the names changed to protect the
innocent:
begin;
-- create a table with some duplicates in one of the columns (y is ck);
wsprague=# select x, x%4 as y into temp fbar from g
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults to connecting to the local machine unless you tell it
otherwise, so this is redundant; though it certainly won't do any harm
either.
Ray.
---
On 09/03/2008 18:49, Mitchell D. Russell wrote:
I think the database was set to SQL_ASCII before I dumped it, because
when I did the 2^nd restore last night to a new SQL_ASCII database, it
worked fine, so that’s where I am at right now, the database is running
fine on 8.3 as SQL_ASCII but I do
On 2008-03-09 11:49, Mitchell D. Russell wrote:
Dean:
I did the dump as so: psql –Upostgres databasename > c:\temp\dump.sql
I assume you meant pg_dump, not psql.
I think the database was set to SQL_ASCII before I dumped it, because
when I did the 2^nd restore last night to a new SQL
Justin,
I'm really not a expert in this area, on how to code this, or functions in
PostgreSQL. All I could offer is some ideas which you might try. Sometimes
this is all it takes. Perhaps someone else will respond that might be more
helpful. With that said I have read in the documentation the use
DMP you did give me an idea on how to call the append array
sfunc looks like this
create or replace function wcost_average_sf (numeric[], numeric, numeric)
returns numeric[] as
$Body$
begin
return array_append(array_append($1, $2), $3);
end;
$Body$
LANGUAGE 'plpgsql' VOLATILE;
t
Lewis,
> > I have no problem with having a policy or following a policy. My
> > problem is: Where is it? When was the last time someone's blog was
> > booted from planetpostgresql? Is it documented, i.e. an "open &
> > discussed" event?
Actually, the policy was discussed on pgsql-www mailing
Dean:
I did the dump as so:
Psql –Upostgres databasename > c:\temp\dump.sql
I think the database was set to SQL_ASCII before I dumped it, because when I
did the 2nd restore last night to a new SQL_ASCII database, it worked fine, so
that’s where I am at right now, the database is runni
If i use two arrays how do i append new entries into these arrays.
array_append only allows for 1 dimension.
what other methods are there to add new entries to the array.
dmp wrote:
Array appends are usually a performance hit, as you said. I'm not sure
though with
PostgreSQL. Why not try it
Array appends are usually a performance hit, as you said. I'm not sure
though with
PostgreSQL. Why not try it with two arrays and see what happens. At
least you would
reducing the single array and the eliminating the append.
danap.
I got the aggregate function for weighted average done. I fi
I got the aggregate function for weighted average done. I finely left
alone for more than 10 minutes to actual get it written. It takes 2
value input Weight and the Value. it will sum the weighted entries to
create the constant then does the normal formula, but does not
percentage number
akshay bhat wrote:
HELLO
i have psql file which is to be used for loading a database
it was downloaded from this link http://conceptnet.media.mit.edu/
the description says
The ConceptNet 3 database, as a PostgreSQL input file. You will need to
be running a PostgreSQL server to install ConceptNe
On Sat, Mar 08, 2008 at 10:49:02AM -0800, Colin Fox wrote:
> David Fetter wrote:
> > On Fri, Mar 07, 2008 at 01:22:49PM -0800, Colin Fox wrote:
> >
> >> I've created a pg_foundry project for this.
> >>
> >> Assuming the project gets approved, I'll post the link here.
> >>
> >
> > Wouldn't i
On 2008-03-09 01:45, Mitchell D. Russell wrote:
New to the list, so please forgive me in advance :)
I've been running 8.2 on windows server 2003 for quite some time now.
The database that I take care of stores records with various languages
in it (russian, chinese, etc) and has been working
On Sun, Mar 09, 2008 at 06:12:14AM -0400, Mitchell D. Russell wrote:
> Just as an update to this matter, I created another new database with
> SQL_ASCII encoding and imported the data, and it worked fine, however, I
> don't think that's the best solution because SQL_ASCII's not a good way to
> have
Just as an update to this matter, I created another new database with
SQL_ASCII encoding and imported the data, and it worked fine, however, I
don't think that's the best solution because SQL_ASCII's not a good way to
have the database encoding set, right?
Thanks again for any suggestions.
New to the list, so please forgive me in advance :)
I've been running 8.2 on windows server 2003 for quite some time now. The
database that I take care of stores records with various languages in it
(russian, chinese, etc) and has been working fine.
I did a PG_dump of the database tonight, and
23 matches
Mail list logo
