Hi,
I know it has been posted before, but it's been some time since that
and there has been no definitive (good) answer, so: has anyone been
able to build and use PL/Ruby with postgres 8.3 on windows? I have had
no problems on my linux machine, but now I need to get it working on
windows...
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do i do
this?
On Sat, Sep 6, 2008 at 10:21 AM, brian [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do
On Sat, Sep 6, 2008 at 10:32 AM, Jorge Godoy [EMAIL PROTECTED] wrote:
Em Saturday 06 September 2008 14:12:49 [EMAIL PROTECTED] escreveu:
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use
vResult;
END LOOP;
RETURN;
END $BODY$
LANGUAGE 'plpgsql' VOLATILE;
SELECT * FROM fun_orderreport(NULL,NULL,NULL);
Thanks,
MuraliDharan V
-Original Message-
From: Gnanavel Shanmugam [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2008 12:11 PM
To: Sathish Duraiswamy
Hi,
Iam new to Postgresql, now i need to create a Dynamic SQL Query for
returning the record set
based on my Input Parameters. I looked up some of the documents and worked
out some more ...
MY Postgresql Version In Local: 7.4
MY Postgresql Version In Development: 8.2
-- DROP TYPE ORDERREPORT;
with your result set using FOR ..LOOP but mine
is not a normal query. it was built Dynamic based on my Input Parameters.
Please look and tell me if you are not clear with my query.
Thanks,
MuraliDharan V
From: Sathish Duraiswamy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12
Please understand.
I know I have to use FOR . LOOP for my query. But it is not a normal one .I
use to build that one dynamically.
From: Willy-Bas Loos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2008 5:46 PM
To: [EMAIL PROTECTED]
Cc: Sathish Duraiswamy; pgsql-general
On Aug 12, 8:17 am, [EMAIL PROTECTED] (ries van Twisk) wrote:
On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
reproduced it on:
PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.3 (Ubuntu 4.2.3-2ubuntu7)
3 rows with index, 2 rows without.
can not reproduce
line 30 at for over execute
statement
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2008 6:53 PM
To: 'Willy-Bas Loos'
Cc: 'Sathish Duraiswamy'; 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Need help returning record set from a dynamic sql
query
Hello,
I'm trying to create a messageing service, like in facebook. Basically
a member can write messages to another member. It will have three main
functions. One, basic messaging to another member. Two, notification
from system to a group of members (a list of members), Three, an
update report
Please excuse my lack of mac knowledge. I installed postgresql 8.3 using the
mac os x 1 click installer onto my brand new powerbook. The install appeared
to go very smooth. If I go to Postgresql under Applications it appears as if I
can start and stop postgres and open pgadmin. I even
Date: Wed, 23 Jul 2008 14:12:45 -0400
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] mac install question
CC: pgsql-general@postgresql.org
On Wed, Jul 23, 2008 at 1:58 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Please excuse my lack of mac knowledge. I
Try copy (query) to stdout.
For me, psql sits at 4.9mb ram on a 3x10^16 row query.
klint.
Thanks Klint.
Can I use a 'copy to' for a query ? I thought I can only do 'copy
table to stdout'
I will do some tests tomorrow and keep you inform.
Olivier
--
Sent via pgsql-general mailing list
Hello,
I am doing a query via psql on a huge database, and I want to have its
output piped to other unix processes.
As the result set is very big, I've got: out of memory for query
result.
How can I manage that, without playing with cursors, as I do not want
to change the sql query ?
Under
should use to ensure complete compatibility with the other software on the
system.
Thanks for your help!
--
Best Regards,
Lynn P. Tilby
Ph: 480 632-8635
[EMAIL PROTECTED]
Hello,
i have the problem that postgres ist starting and stopping several (up
to 4) processes per minute, so that the error log in windows is
running full, with more than 14 entries every minute.
Does someone know, how to reduce the start and the end of so many
processes, is there a variable or
Wow...so does no one use phppgadmin on servers that they are connected
to via the internet? Or if you do, how do you go about securing it so
that no one snoops your password?
Thanks
On May 16, 12:34 am, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
Hi...
This is as much an apache question
Hi...
This is as much an apache question as anything else, but I think it's
appropriate here.
I've been using phppgadmin on my local machine. Now I've installed it
on a remote server running Ubuntu lts 8.04.
I figured I'd try and put it under ssl/https under Apache (mod_ssl).
I've created a
On Apr 14, 2:17 pm, [EMAIL PROTECTED] (David Wilson) wrote:
For instance, your count of distinct userids is probably not using the
index you just created. If it still isn't using it after you ANALYZE
the table, try rewriting the query using group by (select count(*)
from (select userid from
On Apr 14, 12:34 pm, Chris Browne [EMAIL PROTECTED] wrote:
If the entire purpose of your application is to run COUNT(*)
haha. no. I see your point.
I'll be doing statistical functions on group-by's. So I'll go back
and give it another try with queries like those. And I'll use some
Let me just start off by saying that I *want* to use postgresql.
That's my goal. I do not want to use SQLServer. I'm posting this
message not to slam postgres, but to ask for someone to help me figure
out what I'm doing wrong.
I've used postgres for several years as the backend to web
Thanks for the help guys,
I should clear up a little what I am trying to achieve I think.
The primary users of this db and application will be located in an
office, each user with a desktop machine, all networked. They need to
work with this DB in a fairly heavy kind of way, in so far as to say
Hi Guys,
I have been testing / working with Postgres for a work project, and so
far I am really impressed with this DB system. Takes a little getting
used to, but I am really beginning to love it.
I am looking now at a scenario that does not seem to be a native
ability of Postgres, but might
Hi Sam,
Thankyou for the suggestions. They make perfect sense to me. I
appreciate your time and input. The lack of optimiser usage was
something that I had not considered, and I thank you for making me
aware of it.
Cheers
The Frog
--
Sent via pgsql-general mailing list
BUMP
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Everyone,
I am wanting to ask some opinions on implementing PL/R into V8.3 on
Win32. I have a need to be able to perform some relatively demanding
statistical functions as the basis of producing data for reports.
In short R appears to have more than enough capability to do the job
(from a
Apologizes if this has already been announced -
http://www.scribd.com/doc/551889/Introducing-Freebsd-70
a presentation of the SMP in FreeBSD 7.0 using PostgreSQL and MySQL to
produce benchmarks.
Notable quotes -
a) MySQL degrades after utilizing all CPUs, while PostgreSQL does not
(the
Hi,
I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).
As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.
AFAIK stopping the server, zipping data dir, and
I solved my problem :)
the problem is in the query that calls my function:
select * from calcolo_inventario('26','2008-02-22','05')
where giacenza 0
because the resulset has a negative row that doesn't appear on screen
Thank you very much to all of you
Enrico
---(end
Hi,
Thank you guys.
Enrico Sirola wrote:
Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto:
1) PostgreSQL only support partition by inheritance, and rules have to
be created for each child table, this will result *a lot of* rules if
the number of child tables is large
transaction is aborted, commands ignored until end of
transaction block
ROLLBACK
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Hi all,
I'm trying to create a very large table with more than 0.6 billion rows,
which is really a big number, so I think I have to create partitioned
tables after some googling.
However, I have a few questions about partitioning in PostgreSQL.
1) PostgreSQL only support partition by
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi
I'm experimenting with PostgreSQL 8.3.0 on Windows connecting via ODBC. One
curiosity so far is this:
If I use pgAdmin and run SELECT catalog_name FROM Information_Schema.Schemata
I get data back as expected.
If I connect via ODBC and issue the same query I don't see any data. SQLFetch()
Hi
My porting experiment has encountered the SQL Server UniqueIdentifier problem.
I can see one or two suggestions about this have been made over the years but
I'd like to try and stay close to the original. So:
I'm wondering if I can use a combination of a domain 'hack' for syntatic
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each molecule are the same, but values differ). The number
of
'''
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Jorge Godoy wrote:
Have you checked your code and seen what is really happening on these clicks?
I have been trying to catch the error from within php, however
PostgreSQL (in the described case) dies in a way which does not return
any error.
The error returned is that php can't connect to
Hi,
my db structure relays on the OIDs of tables (stored as OIDs of
pg_class).
However, 'pg_dumpall -o ...' seems to save the oids of all data but not
the tableoids, so, when I restore data I get different tableoids than I
had before!
Is there anything I could do to backup and restore even the
Hi,
what's an alternative to tableoids?
As I've learned today they are not consistant across pg_dump/restore.
I need to point to (lots of dynamically added) tables and used tableoids
before.
Are there other solutions to point to tables besides using tableoids
or wasting disk space using the
Hi,
when committing a transaction returns with an error: Do I have to
rollback the transaction in this case?
Felix
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Good morning everyone!
As you may have guessed from previous posts, i just recently migrated my
main database server from 7.4.x to 8.1.11. This part went pretty smoothly.
:)
One of the client machines in my architecture is a Fedora Core 4 box. I
unfortunately cannot change this so I had to
Hello All
I recently ran out of disk space on the volume hosting my default
tablespace. As it turned out, the sysad didnt allocate all of the disk to
the volume when he installed it, so he resized the volume and restarted the
database. The server came up fine so I assumed all was well ( the
and running.
Thanks
-bill
On Jan 4, 2008 3:42 PM, Tom Lane [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
lo_creat fails with:
ERROR: large object oid already exists
Well, does it?
What PG version is this? I'm suspicious that it's pre-8.1 and the
problem
Thank you both!! That got me back up and running ( for now ). Hopefully
this will give me enough enough time to finish the migration next week.
Thanks again!!
On Jan 4, 2008 4:21 PM, Alvaro Herrera [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Is there anyway to force 8.0 to start
Hi all,
I have a table like this,
CREATE TABLE mytable(
avarchar(40),
btext,
ctext,
PRIMARY KEY (a, b)
);
What I want to do is:
insert a record into a table, and when the record already
exists(according to the primary key), update it.
I know that there is a ON DUPLICATE
Hi all,
I have a table like this,
CREATE TABLE mytable(
avarchar(40),
btext,
ctext,
PRIMARY KEY (a, b)
);
What I want to do is:
insert a record into a table, and when the record already
exists(according to the primary key), update it.
I know that there is a ON DUPLICATE
Michael Glaesemann wrote:
On Dec 24, 2007, at 22:03 , [EMAIL PROTECTED] wrote:
I have googled and currently the only way I can find is do query first
and then update or insert.
Or alternatively, UPDATE and see if you've affected any rows. If not,
insert.
Michael Glaesemann
grzm
Hi
I am trying to upgrade my database from 8.0 to 8.1 and am looking for a
little info/advice.
This is a production database that we are migrating and it is in CONSTANT
use, so the maintenance window must be small and hopefully mostly off-hours.
We use a PITR/LVM snapshot solution for our
Good morning to everybody,
I've to resolve this situation: I've a collection of many different databases, all identical, and the name of those databases is stored inside a table in another central
management database.
In an ideal world, I'd like with a single query to be able to recover the name
The C version:
http://downloads.sourceforge.net/vtd-xml/c_tutorial_by_code_examples
The C# version:
http://downloads.sourceforge.net/vtd-xml/CSharp_tutorial_by_code_exam...
The Java version:
http://downloads.sourceforge.net/vtd-xml/Java_tutorial_by_code_exampl...
Also some latest
Hi All,
Not sure if this is a slony issue or a postgres issue...I'm posting on
both.
I'm running slony on a one master/two subscriber system. One of the
subscribers seems to get stuck on a group of queries, and I can't seem
to figure out why. If I do a select on pg_stat_activity, I get the
Hi,
I'm currently using a PostgreSQL DB on my disk memory, but right now I need to
split this DB in this way:
a. the first DB (or first DB partion) will be stored in the Flash
memory and it will contain the system configuration values;
b. the second DB (or second DB partion)
I initialized a database directory and it started fine. But when I tried to
create user I got this error.
Can you tell what is wrong?
thanks
createuser --superuser --createdb --createrole -P postgres
Enter password for new role:
Enter it again:
createuser: could not connect to database postgres:
I have Apache/php/PostgreSQL on FreeBSD, all latest stable versions.
Every time, after mass import into the database (it's a development
server, so the import updates the database with full dump from the
production server) - the first several clicks on the development web
site return -
i tried to restore a dump from 8.2.5 in which i had used tsearch2 and
contains lot of tsearch2 index. when i tried to restore it to 8.3beta it
complained about 'unknow command \r\n' . i know it is from tsearch2. doesnt
8.3 have tsearch2 enabled by default?
with 8.2xx i used to create a database
an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hello,
I need to import between 100 millions to one billion records in a
table. Each record is composed of two char(16) fields. Input format
is a huge csv file.I am running on a linux box with 4gb of ram.
First I create the table. Second I 'copy from' the cvs file. Third I
create the index on
On Sep 12, 3:05 pm, [EMAIL PROTECTED] (D. Dante Lorenso) wrote:
Pavel Stehule wrote:
2007/9/12, Jay Dickon Glanville [EMAIL PROTECTED]:
- I write a function (it doesn't matter what language it's in:
PL/pgSQL, PL/Java, etc)
- I register that function as a post-commit callback function
On Sep 4, 10:54 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
Phoenix Kiula [EMAIL PROTECTED] writes:
Would appreciate any help. Why do indexed queries take so much time?
It's a simple DB with 10 relations including tables and indexes.
Simple inserts and updates, about 5000 a day, but non-trivial
On Jul 23, 5:18 am, [EMAIL PROTECTED] (Gavin M. Roy) wrote:
You might want to look at pgBouncer to pool your drupal pgsql needs. I've
found with 2000 needed connections, I can pool out to only 30 backends and
still push 8k transactions per second.
How you do use pgBouncer -- through
!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
We recently moved to PITR backup and recovery solution as defined in the
documentation. Our basic setup executes the backup start command, and then
takes a snapshot of the filesystem and backups wal files. However, we have
database files ( not wal files ) that change while the system is in
On Jul 23, 6:11 am, [EMAIL PROTECTED] (Raymond O'Donnell) wrote:
On 23/07/2007 11:04, Andy Dale wrote:
The posgres command in the loop should look like so (not sure about the
password):
As I understand it, you supply the password via a pgpass file - you
can't include it on the command
Hello,
I use the following command SELECT * FROM employees ORDER BY name
(a very simple sql statement) the main thing here is that I get a
list ordered without taking into accound the spaces. For example, I
get the following listing:
ABAB
AB CD
ABD E
AB EF
and what I
can't see to problem key
Thx,
Lhaj
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Jun 9, 8:12 am, Rodrigo De León [EMAIL PROTECTED] wrote:
On Jun 8, 7:59 pm, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
i have 4 tables :
date_table (date_id,.)
A_table(A_table_id, something1,something2.)
A1_table(A1_table_id references A_Table(A_Table_id),A11,A12
i have 4 tables :
date_table (date_id,.)
A_table(A_table_id, something1,something2.)
A1_table(A1_table_id references A_Table(A_Table_id),A11,A12)
A2_table(A2_table_id references A_Table(A_table_id),A21,A22,...)
so i want to create a view with
, what log level would it be at?
If this doesn't get logged, could I make this a feature request?
Thanks!
--Richard
On Apr 15, 6:35 am, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
I'm just wondering if autovacuum is ever supposed to vacuum the entire
database during one of its runs. As far
Richard Huxton wrote:
Did you try pg_last_error()?
pg_last_error() does not seem to work. It requires connection as
parameter, so if pg_connect() fails - it has nothing to operate on.
Or am I missing something?
Are you logging connection attempts/failures? Details in the manuals.
Richard Huxton wrote:
Try some code like this:
OK I'll try it now and write back.
Thanks!
Iv
---(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
Hello,
we migrated a php code from FreeBSD 5.x, PostgreSQL 8.x and php 4.x - to
the latest versions of these, keeping the configuration options. Now
pg_connect started to fail on irregular intervals for no obvious reason.
Before we had a problem with the number of connections, but we
Richard Huxton wrote:
[EMAIL PROTECTED] wrote:
What other variable (which are sometimes there, sometimes not) reasons
there can be pg_connect to fail?
What result-code/error do you get? What do your logs show?
I have -
$connection = pg_connect($host $db $user $pass);
When I get the error
, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
hi all,
I installed postgresql 8.2.3 in a freebsd server, my client application is
written in C++ builder + zeoslib and I haven't any problem until now, but now
with 8.2.3 version I have many connection that remains in FIN_WAIT_2, any
suggest?
regards,
Enrico
---(end of
After change the SQL clause to SELECT * from mytable WHERE mykey=$1::int8,
the binding passed!
Thanks for everyone's reply.
- Original Message
From: Tom Lane [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, April 19, 2007 8:41
Hi all,
I'm using Solaris 10 with 64-bit libpq library.
I wanted to bind a 64-bit integer, but it failed:
ERROR: incorrect binary data format in bind
parameter 1.
The code would succeed if the type of val is
uint32_t.
Doe anyone know how to fix this? Thanks a lot!
Hi,
I'm just wondering if autovacuum is ever supposed to vacuum the entire
database during one of its runs. As far as I remember, it's supposed
to vacuum one table at a time, based on the
autovacuum_vacuum_threshold, autovacuum_analyze_threshold, etc.
settings.
For some reason, autovacuum
Sorry, I forgot to also mention that I am running this on a machine
with 80GB free disk space, and 1GB RAM (but I wouldn't think that this
would be the problem, would it?)
--Richard
On Apr 13, 9:25 am, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
I'm trying to run a query to find
Hi,
I'm trying to run a query to find the median value, organized by
date. However, when I run the query, it runs for about 4 hours, and
then quits with the following message:
ERROR: could not write block 10447102 of temporary file: No space left on
device
HINT: Perhaps out of disk space?
On Apr 12, 8:13 pm, Karen Hill [EMAIL PROTECTED] wrote:
I was wondering if DTrace could tell me how many inserts are being
done in a pl/pgsql function while in a loop for example. As you know
a pl/pgsql function executes in a single transaction so the DTrace
probe transaction__commit(int) I
Martijn van Oosterhout wrote:
To use the superuser connections you need to login as superuser...
Eh... OK. I feel a bit stupid :) Thanks ;)
Iv
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Albe Laurenz wrote:
You can connect as superuser on a different connection and issue that
SELECT statement.
OK
But I wouldn't do that. What if there is a problem and all availaible
superuser connections are exhausted? You would not be able to connect
to the database any more, even as
I need to do like 1000 inserts periodically from a web app. Is it better to
do 1000 inserts or 1 insert with the all 1000 rows? Is using copy command
faster than inserts?
thanks
On 4/2/07, Chris [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Hi
I am trying to insert multiple values
hello,
we have a php application which gets from time to time database errors
which look like there are not enough connections (we have 100
connections allowed to postgresql) -
i read that there are two db connections reserved for su. is there a way
to use them from php in order to check if
Hi
I am trying to insert multiple values into a table like this.
INSERT INTO tab_name (col1, col2) VALUES (val1, val2), (val3, val4)
This works in postgres version 8.2.1
My production server runs in 8.1.5. It gives me
ERROR: syntax error at or near , at character 35
What to do?
thanks
Hi,
Does anyone know of any apps using PostgreSQL to archive their
personal email and make it searchable? And that runs on Mac OS X?
thanks,
matt
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Ok thanks i've fixed.
The problem is with 8.2.3 installer, i tried 8.1.8 and I had no problem.
Thanks
On 3/15/07, Dave Page [EMAIL PROTECTED] wrote:
--- Original Message ---
From: Alvaro Herrera [EMAIL PROTECTED]
To: Dave Page [EMAIL PROTECTED]
Sent: 15/03/07, 22:32:50
Subject
, [EMAIL PROTECTED] (Bill Moseley) wrote:
My trigger is very simple:
CREATE OR REPLACE FUNCTION audit_template() RETURNS TRIGGER AS '
BEGIN
INSERT INTO template_history
( template_id, path, content, last_updated_time,
person
On Mar 4, 11:34 am, [EMAIL PROTECTED] (Sandeep Kumar
Jakkaraju) wrote:
how to pass an array to the plpgsql function from Java Code ??
If nothing else, you could use the ARRAY[] constructor:
int [] ar = {1,2,3};
PreparedStament pre= connection.prepareStatement( select
test(ARRAY
You could use COUNT() in conjunction with NULLIF:
select Type,
count(nullif(Active, false)) as Active Count,
count(nullif(Active, true)) as Inactive Count,
100 * count(nullif(Active, false)) / count(*) as Active Percent
from table_name group by Type
On Feb 23, 2:50 pm, Mike [EMAIL PROTECTED
', '[^0-9]+', ',', 'g'), '^,|,$', '', 'g'),',');
{4,4,1,8}
On Feb 23, 10:18 am, [EMAIL PROTECTED] (Anton Melser) wrote:
On 23/02/07, Tom Lane [EMAIL PROTECTED] wrote:
Anton Melser [EMAIL PROTECTED] writes:
I need to be able to get all the matches for a particular regexp from
a text
I searched on postgreSql site and found
a topic Stored Procedure Example. But actually, they
showed how to write a function on postgreSql database.
A procedure is a function with a return type of void.
---(end of broadcast)---
TIP 4: Have you
, Does anyone know of a good linux hard drive test/
verification tool?
-jay
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message
Hi,
I'm using postgresql 7.4. If I execute SQL Select statement, then the
records fold around lines.
I would like to turn this off, so that lines do not fold.
I know the option in less, which one has to set to -S. I have
exported the variable and it works with textfiles.
However, if I use psql
On Feb 8, 8:54 am, Hannes Dorbath [EMAIL PROTECTED] wrote:
On 07.02.2007 17:59, [EMAIL PROTECTED] wrote:
Is there any form of manual for DBI-link out there?
Any link is greatly appreciated!
I think all available documentation comes with it in various README
files. Do you have a specific
\1\0 \3 @\236z
\3\200..., 8192) = 8192
read(158, [EMAIL PROTECTED] \3 @\236z
\3\200..., 8192) = 8192
read(158, \2\0\0\0\310\350\32\307\1\0\0\0d\0\220\0\0 \3 \230\236...,
8192) = 8192
read(158, \2\0\0\0\330\t\33\307\1\0\0\0`\0`\1\0 \3
\200\236\372\2..., 8192) = 8192
read(158, \2\0\0\0\20+\33\307\1
1 - 100 of 225 matches
Mail list logo