[GENERAL] Query Improvement??

2017-11-05 Thread Bret Stern
o) as vendor_locations from ( SELECT distinct primary_vendor_no, company_code FROM combined_item_master group by primary_vendor_no, company_code ) as a group by primary_vendor_no having count(primary_vendor_no)=3 order by vendor_locations DESC, primary_vendor_no Thanks Bret

Re: [GENERAL] import CSV file to a table

2017-03-08 Thread Bret Stern
I'll throw in. If tab delimited is available, perhaps that option will work better...or.. use Access to find the violations of the quote comma delimited assumptions, then export from Access an import Bret On Wed, 2017-03-08 at 08:36 -0800, Karl Czajkowski wrote: > I believe that in i

[GENERAL] Query help

2016-10-04 Thread Bret Stern
;'";"''";"92831";"''";"''" "EBC";"00";"AGORA";"30";"Agora Natural Surfaces";"''";"''";"''";"''";"''";"90248";"''";"''" "EBC";"00";"ARIZ01";"30";"Arizona Tile";"''";"''";"''";"''";"''";"94550";"''";"''" "SNJ";"00";"AKDOP";"30";"AKDO Pacific";"''";"''";"''";"''";"''";"94545";"''";"''" "SNJ";"00";"AGORA";"30";"Agora Natural Surfaces";"''";"''";"''";"''";"''";"90248";"''";"''" "SNJ";"00";"ADEXU";"30";"ADEX USA";"''";"''";"''";"''";"''";"92831";"''";"''" What I need is a query which I can modify to return only vendors which exists in all three company_code columns ( BUR, EBC, SNJ) (they represent showroom location) eg; exists in BUR, EBC, SNJ ADEXU AGORA OR modify the query to return only the vendors which DO NOT exist in all three showrooms based on the first column company_code eg; AKDOP only exists in BUR and SNJ ARIZ01 only exists in EBC Thanks Bret

Re: [GENERAL] Multi-Table Insert/Update Strategy - Use Functions/Procedures?

2016-01-27 Thread Bret Stern
On this track (possibly unrelated)...can a view be used as part of the multi table update Just curious On Wed, 2016-01-27 at 14:48 -0500, Don Parris wrote: > I have several tables related to people and their contact information, > and want db users to be able to add or update a given person and

Re: [GENERAL] Let's Do the CoC Right

2016-01-22 Thread Bret Stern
have used an int...and... why the f%$ckl did you use a godda$%m int you dumb son-of-a-bitchare the same thing to me, but the latter clearly could have cost lives. So for those of us who cannot be offended (no offense). no COC needed. Cheers (no offense) Bret Stern (no offense) ps. If yo

Re: [GENERAL] WIP: CoC

2016-01-12 Thread Bret Stern
ot;, he'll step down. > > THE END > > > Thanks, > Regina > In that vein..Being the insensitive MF that I am, I don't care what Tom says. Toms value (in the list) is his commitment to the project and (for me) the last word on most topics..even if he is a liberal sob. Feel the love, Bret Stern > >

[GENERAL] Code of Conduct

2016-01-11 Thread Bret Stern
Maybe Trump should write this

Re: [GENERAL] Code of Conduct: Is it time?

2016-01-05 Thread Bret Stern
had access to the very best conversations and technical discussions from my fellow decorated contributors. The coc sounds like a Washington politics play, but as long as the best still engage in this forum, I could care less. The list serves its purpose without overhead...a rare resource in today's flood of incoherent technical chatter. Happy New Year! Bret Stern President Machine Management

Re: [GENERAL] native api or odbc?

2015-06-23 Thread Bret Stern
I use odbc in a windows environment. No complaints, can do inserts, select, updates, joins, execute stored procedures with little fuss...more than fast enough for my purposes. There are some issues with 32/64 bit odbc depending on your relative OS..as far as installing the correct odbc version. T

Re: [GENERAL] SSD Drives

2014-04-03 Thread Bret Stern
On Thu, 2014-04-03 at 12:32 -0700, David Rees wrote: > On Thu, Apr 3, 2014 at 12:13 PM, Merlin Moncure wrote: > > On Wed, Apr 2, 2014 at 2:37 PM, Bret Stern > > wrote: > >> Any opinions/comments on using SSD drives with postgresql? > > > > Here's a singl

Re: [GENERAL] SSD Drives

2014-04-02 Thread Bret Stern
Care to share the SSD hardware you're using? I've used none to date, and have some critical data I would like to put on a development server to test with. Regards, Bret Stern On Wed, 2014-04-02 at 15:31 -0500, Shaun Thomas wrote: > On 04/02/2014 02:50 PM, Brent Wood wrote: >

[GENERAL] SSD Drives

2014-04-02 Thread Bret Stern
Any opinions/comments on using SSD drives with postgresql? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Bret Stern
FYI, Pretty sure Apache Office Base has native support to open Access.mdb files on a linux box -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacing Ordinal Suffixes

2014-02-28 Thread Bret Stern
This is a kick *ss forum. I must say. On Fri, 2014-02-28 at 14:17 -0800, Steve Atkins wrote: > On Feb 28, 2014, at 2:04 PM, George Weaver wrote: > > > Hi list, > > > > I'm stumped. > > > > I am trying to use Regexp_Replace to replace ordinal suffixes in addresses > > (eg have '126th' want

Re: [GENERAL] Help with connection issue - started today

2014-02-06 Thread Bret Stern
You checked pg_hba_conf for host 10.68.73.6? Is there a matching log entry for the rejection? On Wed, 2014-02-05 at 09:21 -0200, Edson Richter wrote: > Dear all, I need your advise. Found a tricky situation. > > Without any changes in the configuration files, a **local** connection > to a local

Re: [GENERAL] problem connecting to postgres via apache

2014-01-24 Thread Bret Stern
specific setting would be the next step. On Fri, 2014-01-24 at 11:55 -0800, Susan Cassidy wrote: > I don't actually know what SELinux is. What else will happen if I > (find out how to) disable it? > > > Susan > > > > On Fri, Jan 24, 2014 at 9:47 AM, Bret Stern >

Re: [GENERAL] problem connecting to postgres via apache

2014-01-24 Thread Bret Stern
Are you calling the perl from apache (assuming yes)..? Does the web user have the rights to execute the perl code? Try disabling SELinux.. You'll get it.. On Fri, 2014-01-24 at 09:35 -0800, Susan Cassidy wrote: > I've already checked that. It is enabled. I am running Scientific > Linux. > > >

Re: [GENERAL] Forms for entering data into postgresql

2013-10-11 Thread Bret Stern
Agreed. On Fri, 2013-10-11 at 09:06 -0700, Steve Atkins wrote: > On Oct 11, 2013, at 8:57 AM, Bret Stern > wrote: > > > My interpretation of "Forms these days are written in HTML" means > > most interfaces are web front ends to the cloud. Not a GUI framework. >

Re: [GENERAL] Forms for entering data into postgresql

2013-10-11 Thread Bret Stern
My interpretation of "Forms these days are written in HTML" means most interfaces are web front ends to the cloud. Not a GUI framework. On Fri, 2013-10-11 at 14:47 +0200, Wolfgang Keller wrote: > > Forms these days are written in HTML. > > Only by clueless/careless morons. > > HTML has never bee

Re: [GENERAL] Forms for entering data into postgresql

2013-10-11 Thread Bret Stern
With a brief look at the last 15 years of programming for the web, your comments are a little harsh. Only a short time ago perl and cgi was the rage. I've been programming for 30 years...and still have clients who use Lotus 123 (MS-DOS) based. It's a big world out there, and lots of solutionsf

[GENERAL] Donation

2013-10-10 Thread Bret Stern
I'm amazed how complete pgAdmin, postgreSQL, all the interface options, and this forum works. It's time to reflect. I feel like donating. (Maybe I'll feel the same about our politicians someday) Nnn! Is https://www.postgresql.us/donate the place to donate? -- Sent via pgsql-general ma

Re: [GENERAL] 回复:[GENERAL] SP to calc shipments vs receipts

2013-09-25 Thread Bret Stern
On Wed, 2013-09-25 at 07:46 -0700, Chris Travers wrote: > > > > On Wed, Sep 25, 2013 at 7:27 AM, DDT <410845...@qq.com> wrote: > By the way, you can try to save the current totals to another > table. > update it through triggers when the inventory transactions > c

[GENERAL] Re: 回复:[GENERAL] SP to calc shipments vs receipts

2013-09-25 Thread Bret Stern
n a large set of inventory > transactions for query current totals > > - > > > > > Think I'll just do an UPDATE which changes the ALLOCATED > transaction to a SHIP transaction and uses the current > Ship Date/Time > > On Tue, 2013-09-24 at

[GENERAL] SP to calc shipments vs receipts

2013-09-24 Thread Bret Stern
Think I'll just do an UPDATE which changes the ALLOCATED transaction to a SHIP transaction and uses the current Ship Date/Time On Tue, 2013-09-24 at 07:38 -0700, Bret Stern wrote: > Support at it's finest. > Thinking maybe ALLOCATED transactions zero out > when the allocated

Re: [GENERAL] 回复: [GENERAL] SP to calc shipments vs receipts

2013-09-24 Thread Bret Stern
n trans_type='REC' then trans_qty when trans_type = 'SHP' > then -trans_qty else 0) as on_hand > > but i'm courise about if something is allocated and then it shipped, > will you delete the record or allocation? > > > > > On 9/23/2013 1

[GENERAL] SP to calc shipments vs receipts

2013-09-23 Thread Bret Stern
I have an inventory transaction table with several fields, specifically: part_no trans_type trans_qty part_no | trans_type | trans_qty abc REC 5000(receipt) abc REC 400 (receipt) abc SHP 1000(shipment) abc ALL 1000(all

Re: [GENERAL] Using ODBC and VBA to pull data from a large object

2013-09-17 Thread Bret Stern
On Tue, 2013-09-17 at 08:32 -0400, Adam C Falkenberg wrote: > Good Morning, > > I had a question about using ODBC with large objects. When I query > the pg_largeobject table and return data to an ADO recordset, I can > only get the first 255 bytes even though the record contains 2048 > bytes of

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-08 Thread Bret Stern
PostgreSQL - (the worlds database) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Stored Procedure table/column args

2013-09-02 Thread Bret Stern
On Mon, 2013-09-02 at 18:20 -0700, Adrian Klaver wrote: > On 09/02/2013 06:06 PM, Bret Stern wrote: > > 'psuedo > > > > Can you create stored procedures that are built from parameters as > > below, or does this defeat the pre-compiled purpose of an SP? > >

[GENERAL] Stored Procedure table/column args

2013-09-02 Thread Bret Stern
'psuedo Can you create stored procedures that are built from parameters as below, or does this defeat the pre-compiled purpose of an SP? create function item_exists (tbl character varying, col character varying, col_val character varying) DECLARE x integer; PERFORM col FROM tbl WHERE co

Re: [GENERAL] Update from select

2013-05-13 Thread Bret Stern
> Regards, > > Justin Tocci > Programmer > www.workflowproducts.com > 7813 Harwood Road > North Richland Hills, TX 76180 > phone 817-503-9545 > skype justintocci > > On May 13, 2013, at 3:23 PM, Bret Stern > wrote: > > > PG 8.4 > > > > H

[GENERAL] Update from select

2013-05-13 Thread Bret Stern
s. UPDATE employees SET sales_count = sales_count + 1 WHERE id = (SELECT sales_person FROM accounts WHERE name = 'Acme Corporation'); Many thanks Bret Stern -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [GENERAL] Best import approach? Delimiters in strings

2013-02-16 Thread Bret Stern
The first value seems more suspect, should be "490015496GW". Mixing numeric and string values is best enclosed in quotes. "Golders Green, Golders Green, stop GW" is normal if you want the entire string between the quotes to arrive in a single column (with the comma). On Sat, 2013-02-16 at 17

[GENERAL] Windows Phone/Postgresql

2013-01-30 Thread Bret Stern
I'm thinking about picking up a new windows phone, and would like to connect to a postgresql server from the phone. Anyone have some how-to links. I've done some initial Google searches, and found some leads, but hoping to draw on some experience in the group. Regards, Bret Stern

Re: [GENERAL] "could not write to output file: Permission denied" during pg_dump

2012-11-10 Thread Bret Stern
Sounds like a file sharing issue. In other words..writing to the same file at the same time...from two separate pg_dump streams. Perhaps adding a time var to the file name call below and see if the error goes away. On Sat, 2012-11-10 at 08:03 -0600, Tefft, Michael J wrote: > We have several Post

Re: [GENERAL] Re: Suggestions for the best strategy to emulate returning multiple sets of results

2012-10-10 Thread Bret Stern
create a ramdrive On Wed, 2012-10-10 at 14:27 +0100, Seref Arikan wrote: > Hi Merlin, > Thanks for the response. At the moment, the main function is creating > two temp tables that drops on commit, and python functions fills > these. Not too bad, but I'd like to push these temp tables to ram, > w

Re: [GENERAL] Add a check an a array column

2012-09-08 Thread Bret Stern
On Sat, 2012-09-08 at 21:24 +0200, Andreas Kretschmer wrote: > Joel Hoffman wrote: > > > More concisely, you can compare directly against all values of the array: > > > > # create table i (i int[] check (0 <= ALL(i) AND 1023 >= ALL(i))); > > # insert into i values (ARRAY[0,1,2,3,1023]); > > # in

[GENERAL] libpq Windows 7 64

2012-05-31 Thread Bret Stern
Got a new fancy pants Dell T3500 Windows 7 Ultimate 64 bit machine. PostgreSql 9.1 Trying to port a 32-bit XP libpq console app with Codeblocks. Seems like the libpq.lib isn't linking quite right as the PQ_Connectdb, PQstatus etc lib functions are reported as undefined. Anyone out there get Win

[GENERAL] Installer Questions (NSIS)

2012-04-12 Thread Bret Stern
ication is distributed. Is there a list which discusses this, or should I test the waters here when the time comes? Bret Stern -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Regarding NOTIFY

2012-04-09 Thread Bret Stern
On Mon, 2012-04-09 at 09:03 +, Jasen Betts wrote: > On 2012-03-09, Bret Stern wrote: > > We have a concrete batching application composed of two parts. > > 1. The Monitor. > > The Monitor cycles every 60 seconds, and looks into a Postgresql table > > for jobs t

Re: [GENERAL] Move Tables From One Database to Another

2012-03-29 Thread Bret Stern
On Thu, 2012-03-29 at 14:49 -0500, Andy Colson wrote: > On 3/29/2012 2:10 PM, Rich Shepard wrote: > > I'm storing vector map attribute data in postgres tables and somehow > > managed to create two databases (of similar names) rather than one. I want > > to combine the two. > > > > For tables that e

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread Bret Stern
On Mon, 2012-03-26 at 16:16 -0700, John R Pierce wrote: > On 03/26/12 4:05 PM, Tim Uckun wrote: > > Is there a way to backup a database or a cluster though a database > > connection? I mean I want to write some code that connects to the > > database remotely and then issues a backup command like i

Re: [GENERAL] PostgreSQL 64 Bit XIDs - Transaction IDs

2012-03-23 Thread Bret Stern
VoltDB maybe - Original Message - On 06:31 AM 03/23/2012 Frank Lanitz wrote: Am 23.03.2012 14:23, schrieb Adrian Klaver: > I would say either they got the numbers wrong or someone is pulling > your leg. That rate is not going to happen. Maybe twitter or facebook all in all... Cheers, F

Re: [GENERAL] Backups

2012-03-15 Thread Bret Stern
Perhaps a RAM DISK could be considered in the equation On Thu, 2012-03-15 at 16:30 +0100, Albe Laurenz wrote: > Richard Harley wrote: > > Very simple question - does pg_dump/dumpall hit the server in terms > of database performance? We > > currently do nightly backups and I want to move to ho

Re: [GENERAL] Upgrade questions

2012-03-14 Thread Bret Stern
I felt pretty good about my server until I read this. On Wed, 2012-03-14 at 00:24 -0700, John R Pierce wrote: > On 03/13/12 8:41 PM, Carson Gross wrote: > > Does anyone have a reasonable guess as to the inserts per second > > postgres is capable of these days on middle-of-the-road hardware? Any

Re: [GENERAL] Calculated update

2012-03-12 Thread Bret Stern
On Mon, 2012-03-12 at 17:39 -0700, Bosco Rama wrote: > Bret Stern wrote: > > > > trying to update a varchar numeric string column > > by converting it to int, adding a numeric value and insert it back > > as a varchar > > > > Having trouble with cast &

[GENERAL] Calculated update

2012-03-12 Thread Bret Stern
trying to update a varchar numeric string column by converting it to int, adding a numeric value and insert it back as a varchar Having trouble with cast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpr

[GENERAL] Regarding NOTIFY

2012-03-09 Thread Bret Stern
immediately. Can it be used with VB? or Should I use LibPQ? Any suggestions welcome. If this is the wrong list for these questions, let me know? Bret Stern -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Show Databases via ODBC

2012-03-07 Thread Bret Stern
Works perfect. I'll trap and show only our databases to the user. all thanks On Wed, 2012-03-07 at 21:00 +0100, Szymon Guz wrote: > On 7 March 2012 20:36, Bret Stern > wrote: > Is it possible through ODBC to connect to a PostgreSql > server and query for the av

[GENERAL] Show Databases via ODBC

2012-03-07 Thread Bret Stern
Is it possible through ODBC to connect to a PostgreSql server and query for the available databases? When our application upgrades, we typically create a new database. I want to design a form which allows the user to select the old database, which then migrates data to the new (currently connected

Re: [GENERAL] Looking for an intro-to-SQL book which is PostgreSQL-friendly

2011-09-02 Thread Bret Fledderjohn
estions? > > -- > Josh Berkus > PostgreSQL Experts Inc. > http://pgexperts.com > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- - Bret

[GENERAL] Using libpq with Visual Studio 2008

2011-05-18 Thread Bret Stern
Is this list suited for coding questions? I'm using VS2008, connecting to postgresql with libpq and have some initial questions. Regards Bret Stern -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [GENERAL] Web Hosting

2011-03-05 Thread Bret Fledderjohn
G/PHP and I > have no intention of switching. > > Thanks. > I am using A2 Hosting (www.a2hosting.com ) which offers 8.4... They are inexpensive and so far reliable. -- - Bret "Why should I fret in microcosmic bonds That chafe th

Re: [GENERAL] Libpq memory leak

2010-09-24 Thread Bret S. Lambert
On Fri, Sep 24, 2010 at 06:11:31PM +0400, Dmitriy Igrishin wrote: > Hey Vladimir, > > > > 2010/9/24 Polyakov Vladimir > > > Program written in C using Libpq, which receives large files (BYTEA) > > has a memory leak. > > I need to free ALL of the used memory after each sql query. > > > > after

[GENERAL] macro/inline table valued functions

2010-09-21 Thread Bret Green
Is there anything like a macro or an inline table valued function in postgres? i.e I define a query as a function/macro and reuse the function in queries and the dbms will expand the function/macro to its definition, thus avoiding any overhead. If not what is the closest thing? Thanks

Re: [GENERAL] how to insert multiple rows and get the ids back in a temp table (pgplsql)?

2010-09-19 Thread Bret Green
Thanks Any solution without cursors perhaps? From: hubert depesz lubaczewski To: Bret Green Cc: pgsql-general@postgresql.org Sent: Sun, September 19, 2010 7:12:51 AM Subject: Re: [GENERAL] how to insert multiple rows and get the ids back in a temp table

Re: [GENERAL] how to insert multiple rows and get the ids back in a temp table (pgplsql)?

2010-09-19 Thread Bret Green
No I do need it inside pgplsql. I need pgplsql for other stuff. From: Alban Hertroys To: Bret Green Cc: pgsql-general@postgresql.org Sent: Sun, September 19, 2010 9:25:46 AM Subject: Re: [GENERAL] how to insert multiple rows and get the ids back in a temp

[GENERAL] how to insert multiple rows and get the ids back in a temp table (pgplsql)?

2010-09-18 Thread Bret Green
how can I do the following in plpgsql? insert multiple rows in a table get the ids (serial) into a temp table (not the client) for one row it will be like this insert into mytable(mycolumn)values(123)returning id into some_variable; now for multiple rows (using insert select) it will be like i

Re: [GENERAL] What Linux edition we should chose?

2010-06-01 Thread Bret S. Lambert
On Wed, Jun 02, 2010 at 01:32:44AM -0400, Greg Smith wrote: > Nilesh Govindarajan wrote: > >I run my site (see my signature) on a self managed VPS. I was using > >the default PGSQL RPM from the fedora repository, the site was getting > >way slow. So I compiled all the stuff apache, php and postgres

Re: [GENERAL] Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column

2010-02-23 Thread Bret S. Lambert
On Wed, Feb 24, 2010 at 07:51:54AM +0100, John Gage wrote: > This is a two-part question: > > 1) I have a source_text that I want to divide into smaller subunits > that will be contained in rows in a column in a new table. Is it > absolutely certain that the initial order of the rows in the > res

Re: [GENERAL] Multiple buffer cache?

2010-02-06 Thread Bret S. Lambert
On Sat, Feb 06, 2010 at 02:44:32PM +0100, C?dric Villemain wrote: > 2010/2/6 Bret S. Lambert : > > On Fri, Feb 05, 2010 at 11:41:13PM +0200, Alexei Vladishev wrote: > >> Greetings, > >> > >> Is there a way of configuring PostgreSQL so that one specific tabl

Re: [GENERAL] Multiple buffer cache?

2010-02-06 Thread Bret S. Lambert
On Sat, Feb 06, 2010 at 03:46:58PM +0200, Alexei Vladishev wrote: > Bret, > > Thank you for your response! > > >>Greetings, > >> > >>Is there a way of configuring PostgreSQL so that one specific table would > >>use, say, 4GB of buffer cache while o

Re: [GENERAL] Multiple buffer cache?

2010-02-06 Thread Bret S. Lambert
On Fri, Feb 05, 2010 at 11:41:13PM +0200, Alexei Vladishev wrote: > Greetings, > > Is there a way of configuring PostgreSQL so that one specific table would > use, say, 4GB of buffer cache while other tables would use the rest? > > I would like to keep the table and its indexes always in "hot" >

Re: [GENERAL] data dump help

2010-01-18 Thread Bret S. Lambert
On Tue, Jan 19, 2010 at 06:35:10PM +1300, Andrej wrote: > 2010/1/19 Bret S. Lambert : > > > Isn't this just over-engineering? Why not let the database do > > the work, and add the column with a default value of 0, so that > > you don't have to modify wha

Re: [GENERAL] data dump help

2010-01-18 Thread Bret S. Lambert
ation. > > > > Although. I really like your idea so I might create another table > where I will log whether the data has been dumped or not. I just need > to come up with a query to check this with the other table. Isn't this just over-engineering? Why not let the dat

Re: [GENERAL] code example for PQgetCopyData

2009-12-03 Thread Bret
Looks like fun. Tom added some comments on the PQgetCopyData function. If your environment allows, put a breapoint in on the line below and look at the vars while (nLen = PQgetCopyData(pConn, buffer, false) > 0) perhaps this will get you working while (nLen = PQgetCopyData(pConn, &buffer,

Re: [GENERAL] code example for PQgetCopyData

2009-12-03 Thread Bret
_ From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dave Huber Sent: Thursday, December 03, 2009 9:18 AM To: pgsql-general@postgresql.org Subject: [GENERAL] code example for PQgetCopyData Does anybody have a snippet where they use PQg

Re: [GENERAL] optimizing advice

2009-12-01 Thread Bret
> -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe > Sent: Tuesday, December 01, 2009 2:10 PM > To: r.soeren...@mpic.de > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] optimizing advice > > 200

Re: [GENERAL] Synchronize filenames in table with filesystem

2009-12-01 Thread Bret
> -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Atkins > Sent: Tuesday, December 01, 2009 9:44 AM > To: pgsql-general General > Subject: Re: [GENERAL] Synchronize filenames in table with filesystem > > > On Dec

Re: [GENERAL] Allowing for longer table names (>64 characters)

2009-11-20 Thread Bret
-) > > Allan. > > -- > Sent via pgsql-general mailing list > (pgsql-general@postgresql.org) To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general I can't imagine naming a table like you describe. A "users" tab

[GENERAL] Numeric Type and VB/ODBC

2009-11-10 Thread Bret
Case vbDate IsNothing = False Case vbString If (Len(varToTest) <> 0 And varToTest <> " ") Then IsNothing = False End Select End Function Bret Stern -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make c

[GENERAL] Backups

2009-11-08 Thread Bret
chatter. Bret Stern -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ubuntu packages for 8.4

2009-07-09 Thread Bret Fledderjohn
anybody has > an argument as to why I should compile it I am all ears. > I just forwarded your message to Martin Pitt, he's the package maintain for Postgres for Ubuntu (and Debian, I believe). I don't know if this is planned for Karmic Koala (to be released in October). -- - Bret

[GENERAL] using regexp_matches and array manipulation

2008-07-18 Thread Bret Schuhmacher
#x27;ve tried select into, but that just created a table and didn't put the values into an array variable. leaselog=# select regexp_matches('a,b,c','(.*),(.*),(.*)') into foo; Thanks in advance! Rgds, Bret -BEGIN PGP

[GENERAL] PG/Tcl and Expect?

2007-10-18 Thread Bret Schuhmacher
Does the PG/Tcl interface allow expect scripts? I want to create a stored procedure that ssh's to another server and runs a Perl script. Expect could do it, but can I load the expect module from pgtcl? Thanks, Bret

Re: [GENERAL] Suggestions for Remote Procedure Calls from PG, please?

2007-10-17 Thread Bret Schuhmacher
to-do queue idea. Thanks again for your time! Bret -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) iD8DBQFHFtagIeMC5lK637kRAg56AJsF6eNlQWPdpjb8ufiO+xRqZTXymgCfdJFG 4igU9pCasxaVSGOxC0DBbHg= =qKK2 -END PGP SIGNATURE- ---(end of broadcast)

[GENERAL] Suggestions for Remote Procedure Calls from PG, please?

2007-10-17 Thread Bret Schuhmacher
could use XMLBlaster to send a message to the other box to start the other process, but that's an asynchronous call and I can't be sure if the remote procedure ran properly. Does anyone else invoke a process on a remote server? How do you do it? Thanks, Bret -BEGIN PGP SIGNATURE- V

[GENERAL] Status of pgaccess

2007-06-27 Thread Bret Busby
t;, which is not the Debian "stable" distribution. Has any work been done on pgaccess, since 2003 (the assumed date of the latest Debian release of the application package), and, does a version exist, that is compatible with PostgreSQL 8.x? Thank you in anticipation. -- Bret Busby

[GENERAL] Returning multiple rows from a function?

2006-11-27 Thread Bret Schuhmacher
(i.e. select getOnCallVol()), I get this: (Mary,Smith,11,22,33,"","") Is there another way to get each row returned? I played around with making the function return a "SETOF RECORD" and using "RETURN NEXT", bu

[GENERAL] Training and certification

2004-07-08 Thread Bret Busby
.org . Is that the only PostgreSQL certification that is recognised? Is it recognised internationally? Thank you in anticipation, for answers to all of these questions. -- Bret Busby Armadale West Australia .. "So once you do know what the question actually is, you'll

Re: [GENERAL] book for postgresql

2004-05-31 Thread Bret Busby
ed > along with the PostgreSQL installation. > > All four of these sources are quite good. I have all but Bruce's book > on my desk... > For some strange reason, the message above, took somewhat over three months to come through, maybe due to the To address in the header (?

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-31 Thread Bret Busby
soft certifications, I was referring to the MCAD and MCSD certifications. -- Bret Busby Armadale West Australia .. "So once you do know what the question actually is, you'll know what the answer means." - Deep Thought, Chapter 28 of "The Hitchhiker

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-30 Thread Bret Busby
> > Informix and Oracle and Microsoft have such things, from my > > understanding. > > As someone who has passed the MS exams, you don't need them, they are > joke. The A+ was more difficult than the memorize the side bars and > select letter "C" testing th

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-30 Thread Bret Busby
On Tue, 30 Dec 2003, Nigel J. Andrews wrote: > Date: Tue, 30 Dec 2003 11:12:05 + (GMT) > From: Nigel J. Andrews <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] Is my MySQL Gaining ? > > > Just to poke f

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-30 Thread Bret Busby
On Tue, 30 Dec 2003, Tom Lane wrote: > Date: Tue, 30 Dec 2003 02:07:23 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: Bret Busby <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: [GENERAL] Is my MySQL Gaining ? > > Bret Busby <

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-29 Thread Bret Busby
p, and, similarly, with joebloggs and AccountsThing. Likewise with separate ISP accounts and any PostgreSQL databases that they have and use on their web sites. Clarification of whether my understanding is correct, would be appreciated. -- Bret Busby Armadale West Australia .. &q

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

2003-12-29 Thread Bret Busby
tions, this book gives a huge boost to any > newbie. > > And, if a person did not already have it installed and set up, would the person then have not been required to find elsewhere, how to do those? -- Bret Busby Armadale West Australia .. "So once you do kno

Re: [pgsql-advocacy] [GENERAL] Is my MySQL Gaining ?

2003-12-29 Thread Bret Busby
material again, or whether the student can move on. To give a person knowledge, increases the person's memorised information; to require the person to use the knowledge, makes the person learn, and increases the person's skills. That is why I have repeatedly referred to the need for a &qu

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-29 Thread Bret Busby
ngs that I have repeatedly mentioned; formalised, standardised, structured, training and certification, and, a "Teach Yourself PostgreSQLin 21 Days" book, with appropriate set exercises, as in any good trauining course. When PostgreSQL has these, then it will have achieved the maturity o

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Bret Busby
On Fri, 12 Dec 2003, Bruce Momjian wrote: > Date: Fri, 12 Dec 2003 08:41:39 -0500 (EST) > From: Bruce Momjian <[EMAIL PROTECTED]> > To: Chris Travers <[EMAIL PROTECTED]> > Cc: Stephan Szabo <[EMAIL PROTECTED]>, Bret Busby <[EMAIL PROTECTED]>, > [EMAIL

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-10 Thread Bret Busby
stgreSQL. Thus, whilst, if I chose that path, it might not be any great loss, if others followed that path, and, went to MySQL instead of PostgreSQL, due to the lack of formalised training and certification of PostgreSQL skills, it would be a loss of potential usage and acceptance, by PostgreSQ

[GENERAL] unicode/japanese support

2000-08-21 Thread Bret A. Barker
hanks, -bret -- -* bret a. barker -* cto, gamelet.com [ [EMAIL PROTECTED] ] -* take a break, play a game: -* [ http://www.gamelet.com ]