Goal is to return all vendors which exist in all three companies
I think I got lucky figuring this out. Is there an obviously better way?
combined_item_master looks like this:
company_code character varying(10) NOT NULL,
primary_vendor_no character varying(7)
..more fields
data looks like
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 its fully
Good evening,
I'm curious about a way to ask the following question of my vendors
table.
psuedo1 "select all vendors which exist in BUR and EBC and SNJ"
and
psuedo2 "select all vendors which DO NOT exist in all three show rooms
The data is from a Sage accounting system which I pull out and
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
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 you do pull off the Holy Grail (no offense
hanks,
> 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
>
>
Maybe Trump should write this
cal 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
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.
On Thu, 2014-04-03 at 12:32 -0700, David Rees wrote:
On Thu, Apr 3, 2014 at 12:13 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Apr 2, 2014 at 2:37 PM, Bret Stern
bret_st...@machinemanagement.com wrote:
Any opinions/comments on using SSD drives with postgresql?
Here's a single
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
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:
http://it-blog
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
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 gwea...@shaw.ca wrote:
Hi list,
I'm stumped.
I am trying to use Regexp_Replace to replace ordinal suffixes in addresses
(eg have '126th'
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
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.
the 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
bret_st...@machinemanagement.com wrote
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
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 been, is
Agreed.
On Fri, 2013-10-11 at 09:06 -0700, Steve Atkins wrote:
On Oct 11, 2013, at 8:57 AM, Bret Stern bret_st...@machinemanagement.com
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.
Yup
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
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 07:38 -0700, Bret Stern wrote:
Support at it's finest.
Thinking
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
changed.
) 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 10:13 PM, Bret Stern wrote:
I have an inventory transaction table with several fields,
specifically:
part_no
trans_type
trans_qty
part_no
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 qty is shipped, but I
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
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 data
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
'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
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?
create function item_exists (tbl character varying
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.postgresql.org/mailpref/pgsql
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 bret_st...@machinemanagement.com
wrote:
PG 8.4
Having trouble putting together an update query to update
multiple columns in tbl1 from columns
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:02
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
--
Sent
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
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,
which
On Sat, 2012-09-08 at 21:24 +0200, Andreas Kretschmer wrote:
Joel Hoffman joel.hoff...@gmail.com 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
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
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
On Mon, 2012-04-09 at 09:03 +, Jasen Betts wrote:
On 2012-03-09, Bret Stern bret_st...@machinemanagement.com 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 to run
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 exist in
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 it
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,
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 hourly
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
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:
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
I assume you are doing an update as opposed
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
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
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 bret_st...@machinemanagement.com
wrote:
Is it possible through ODBC to connect to a PostgreSql
server and query
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/mailpref
51 matches
Mail list logo