Hi, I try to match different parts of a string delimited by '$$' followed by a letter. Example of a string $$aSingapore ;$$aHackensack, N.J....

Luc Giguere

01-14-2013 03:07 PM
Luc Giguere

Hello guys, please could someone answer my question? how to run a plpgsql script from the command line? is possible to run like that? i hava a set of...

CatrinaJones

07-19-2008 05:22 AM
CatrinaJones

Hi, Is there any way I can have the postgresql daily log files show a time stamp for each message that is logged? I'm referring to the daily log...

Frank Footon

10-26-2007 05:04 PM
Frank Footon

Hello, Been away from PostgreSQL for a while and probably needs retraining in the basics. How do I close a database? Can't even find it in the...

Adam Smith

09-18-2007 08:34 AM
HansH

Hi, I have a user trying to use postgresql on windows but is having trouble getting the basic stuff to work in Java. He has a sample program...

Rick Caldwell

08-13-2007 01:59 PM
Rick Caldwell

Hi all, i'm a real noob in databasedesign, so i have some questions about it. In case i want to make a booklist with two tables and the following...

Juergen Mederer

07-19-2007 03:04 PM
Juergen Mederer

Hi, I'm stuck here. I have a function that I would like to pass a text string and have the function perform ILIKE on that passed string. create or...

Frank Footon

07-10-2007 05:49 PM
Frank Footon

I have an .asp page that passes four variables to another .asp page by using an HTML form. A SQL query then runs against an Access database using...

valntyn via DBMonster.com

03-09-2007 10:23 AM
HansH

Hello, We are running PostgreSQL 7.4.7 on a Linux system. We have a primary DB and hot-standby . A few weeks ago we had a database corruption and...

Shahryar G. Hashemi

01-01-2007 04:29 PM
Shahryar G. Hashemi

US Based Internet development company seeking to establish an ongoing relationship with one programming team. You must be able to develop...

WH

12-11-2006 01:01 PM
WH

What string should i write in the NEW SERVER field (localhost or 127.0.0.1 is not accepted and give me generic error messages).. And in PORT NUMBER...

LeoVInce

12-05-2006 08:25 AM
LeoVInce

I have done database work with Borland C++ Builder and Paradox, and with ..NET and SQL Server and Paradox. I am considering a new projects with ..NET...

Steve Rogers

11-18-2006 01:18 PM
Steve Rogers

I am running postgresql at version 8.1 on a windows xp desktop machine. I then loaded 40 million rows into a table of 6 varchar fields ( The...

Spacen Jasset

10-24-2006 05:16 PM
Spacen Jasset

Hi, Are there any web development libraries for postgresql that support a C++ CGI interface? What I'm dreaming of is a library that defines classes...

Randy Yates

10-05-2006 09:28 PM
Randy Yates

Hi Database Gurus, Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are...

09-26-2006 05:55 AM
Jerry Stuckle

I used MinGW + MSys to compile PostgreSQL 8.1.4 using the sequence: ../configure --no-zlib make make install I am now trying to compile the Qt 3.3...

Tony O'Bryan

08-21-2006 10:45 AM
Tony O'Bryan

I'm told "select distinct on" or even "select distinct" is inefficient because it selects then discards rows. However, I'm stumped to find an...

robert

06-30-2006 07:44 AM
robert

I know nothing about databases, SQL, or PostGreSQL :-) I installed PostGreSQL and phpPgAdmin on a web server. It looks like PostGreSQL insists that...

John Oliver

06-08-2006 07:15 PM
ophidian

I'm running a custom-compiled build of PostgreSQL on Solaris 8 with vacuum full analyze being run every hour. It runs fine, but after a few days of...

Robert Uhl

04-14-2006 10:06 AM
Robert Uhl

Well, I upgraded to Fedora Core 4 and now PostgreSQL won't start, since my data files are from a previous version. A little Googling shows that I...

Robert Uhl

04-03-2006 11:51 PM
Schmidty

I am normally the admin for our PostgreSQL servers, but someone else tried to kill a runaway query while I was out sick. Unfortunately, he...

Tony O'Bryan

04-01-2006 07:31 PM
Schmidty

hi, I'm looking for an open-source tool that will allow me to extract data as XML. thanks for any tips. j

JJC

01-10-2006 09:36 AM
JJC

Another newbie to Postgresql. I need to know where I may find info on setting up two servers on the same machine. I am wanting to examine postgresql...

J. D. Leach

12-20-2005 03:51 PM
J. D. Leach

Hi. I'm new with PostgreSQL, but this thing doesn't allow me to sleep: I wonder if it is possible to execute SQL query which: 1. checks out if...

Bartosz Jakubiak

12-08-2005 03:35 AM
Bartosz Jakubiak

I am using Postgres 7.4.6 i have 3 tables i want to join 3 tables and return a list of route_id to which a specified user_id does NOT...

Gary Townsend

11-25-2005 04:25 PM
Gary Townsend

I have added a field to one of my PostgreSQL tables in the "Timestamp" datatype, but when I add a row to that table I don't get the date and...

Si

11-12-2005 11:52 AM
Stephen Prinster

In a WHERE clause, I want to to compare strings ignoring the spaces inside them. Is therd a function to do that? I do not find it in...

Pierre Couderc

10-24-2005 01:00 PM
HansH

Hi, I have a PG database "foodsvc" and I want to make a copy of it with a new name "newfoodsvc". So that I can play with the "newfoodsve" without...

G Lam

10-21-2005 02:12 AM
Heimlich Manure

I'm emulating ROLAP in Postgres, populating a sorta-cube from a table with 200 million rows in it. Many aggregates over around 20 fields. Two...

Heimlich Manure

10-21-2005 02:07 AM
Heimlich Manure

Makes me glad I chose PostgreSQL to develop my goodies on.... http://developers.slashdot.org/developers/05/10/07/2021211.shtml?tid=221 -- Available...

Scott Auge

10-07-2005 11:00 PM
Scott Auge

How can I execute a query which prompt the user for input? Something like SELECT FROM Table WHERE Name= In Oracle PL/SQL, you use & before variable...

Jack Bauer

09-25-2005 06:14 AM
HansH

Hi, I have a database that was created with the encoding set to SQL_ASCII. A lot of data comes with accented characters. When reading this data with...

dDave

08-15-2005 12:11 PM
dDave

Hi, Would someone please help me with this question. I have the PDF file but I would like to read HTML. On...

Bernard

08-12-2005 07:42 PM
Bernard

Sorry for the seemingly novice posting, but I could find a solution for this on the web so far... I've been developing a database using postgresql...

Jeff D. Hamann

08-02-2005 08:09 PM
Jeff D. Hamann

I am working with an application whose performance is limited by the write activity (inserts, updates and deletes) on three specific tables....

Emil Briggs

06-22-2005 10:43 AM
Emil Briggs

Hi, I am hitting an issue when using SCROLL CURSORS. -->My Setup: PostgreSQL 8.0.3 on Windows XP Pro SP2 -->My Test Function: CREATE OR REPLACE...

Larry Morroni

06-21-2005 08:15 AM
Larry Morroni

Hi, Can anyone recommend a tool or command which displays the SQL being sent from an application connected to a Postgres server? (I.e.,...

krog

06-20-2005 11:32 AM
krog

I've searched unsuccessfully on google and the archives for a technical comparison of Oracle and PostgreSQL. Is there any free and recent comparison...

Nadeem Bitar

06-13-2005 06:42 PM
John

I want to order a text field which contains some words which begin with a single quote, if however I perform the following query, the single quote...

Hugo Coolens

05-11-2005 12:06 AM
Hugo Coolens

Dear All, I am newbie in postgresql, i am using postgressql 8.0 for windows and i try using crosstab for my table. my table structure is account_id...

M Fadhilah via DBMonster.com

04-28-2005 04:54 AM
M Fadhilah via DBMonster.com

I've looked through all the documentation and I think I am all out of luck. I was wondering if when declaring a statement-level trigger whether I...

Simon Reye

04-25-2005 09:36 PM
Simon Reye

I am currently migrating from MSDE to PostgreSQL and have to rewrite the function that is calculating next date of sampling... In MSDE there is a...

Zlatko Matiæ

04-19-2005 05:48 AM
Zlatko Matiæ

Is it possible to use dynamic parameters in Pg views (for example criteria for filtering start/end date) ? On MSDE there are "in-line" functions...

Zlatko Matiæ

04-17-2005 05:05 PM
Zlatko Matiæ

Hello. While I was working with Access Projects (Access front-end with MSDE) I was able to call stored procedures by using ADO command and...

Zlatko Matiæ

04-17-2005 04:39 AM
Zlatko Matiæ

Hi, I am trying to implement a few functions in Plpython (in Postgresql 8.0.1). However, I could find the solution in the documentation, so I would...

RL

03-29-2005 06:12 AM
RL

Hey guys, I am wondering if there is a module that when I query the database and it returns the resultset in xml format. eg. select name,gener from...

glin@tollnz.co.nz

03-27-2005 12:13 PM
majortool

First - I'm not sure whether this should go to .bugs, .hackers oder ..sql, so I posted here :/ The query and the corresponding EXPLAIN is...

Hannes Dorbath

03-23-2005 09:55 AM
Hannes Dorbath

Is there any particular reason there are no bitwise operators (I'm looking for XOR, specifically) for the bytea data type? Any plans to add...

Nick Johnson

03-22-2005 09:52 PM
Nick Johnson

i have a stored procedure that goes Create function myfunction(bytea) returns void as 'update tbl_entity SET Right_Thumb = $1;' language sql the...

scott johnston

03-22-2005 12:31 PM
scott johnston

The short question is why does this: select to_tsvector('default', coalesce(name, '') ||' '|| coalesce(description, '') ||' '||...

Justin Kennedy

03-18-2005 06:52 AM
Justin Kennedy