I have a table that looks like this:
homeidcity date measurement pre/post
123 san francisco 1/2/2003 1458 pre
123 san francisco NULL 1932 post
124 los angeles2/4/2005 938 pre
124 NULLNULL
(*)>1 )
I'm looking for a better way, since I am just adding the three columns
together right now.
Jeffrey
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi, I wonder if I might tap the vast knowledge here againg.
I have a perl script that is looping through a statement handle like this.
$statement = "select * from sometable";
$sth=$dbh->prepare($statement);
$sth->execute();
# here is the part I have a question about.
while (%hash_ref = %{$sth->
AIL PROTECTED]>
> Date: Wed, 12 Apr 2000 12:45:42 +0100
> To: "Jeffrey" <[EMAIL PROTECTED]>, " " <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Perl error: fetchrow_hashref failed
>
>
> - Original Message -
> From: "Jeffre
Hi,
I am having trouble catching errors from postgress. I am connecting to the
database via perl and DBI.pm The following will work
($dbh = DBI->connect("$dsn", "", "") ) or (print $DBI::errstr and exit());
But this wont (from deliberately spelled wrong)
($sth=$dbh->prepare("select * form table
Greg,
I had a similar problem. An application that did lots of complicated queries
constantly running out the server out of ram. I started watching the server
with TOP set to .5 seconds and saw the postmaster swell up to 300+mb for
15seconds at a time!
After several of those queries would run (10
On 6/17/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
On 6/18/07, John K Masters <[EMAIL PROTECTED]> wrote:
> I feel somewhat embarrassed to post this but I can't get past the first
> post with Postgresql. I have installed onto a Debian testing system,
> created a space for the database clust
Hello all
As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6
(64bit) is broken.
On a fresh RHEL6.3 (64-bit) installation, as root, run the following
commands:
rpm -i
http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm
yum update
(As stated in
the issue is, but would
you mind giving it another shot..? Things should be calming down at
this point.
Thanks!
Stephen
* Jeffrey Jones (jjo...@toppan-f.co.jp) wrote:
As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6
(64bit) is broken.
On a fresh R
information from what has been written already.
Is there a way I can get the metadata file directly so we can see the
raw file and compare it?
Thanks
Jeff
On 13/02/13 17:10, Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2013-02-13 at 12:03 +0900, Jeffrey Jones wrote:
As I can tell the PostgreSQL 9.2 yum
Actually, the URL for the meta-data file is right there in the error
message.
I will do a wget and see if I can see anything obviously wrong.
On 13/02/13 17:27, Jeffrey Jones wrote:
Hello Devrim
I have run the commands as you specified but unfortunately the error
pops up again when I run
,
On Wed, 2013-02-13 at 17:27 +0900, Jeffrey Jones wrote:
I have run the commands as you specified but unfortunately the error
pops up again when I run yum makecache.
Same error? That is *almost* impossible -- makecache is the parameter to
get rid of that error, not to see that error. Could you
Hi Devrim
Damn, sorry that was a typo, I had to manually copy the output, sorry.
Thanks
Jeff
On 14/02/13 01:08, Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2013-02-13 at 17:49 +0900, Jeffrey Jones wrote:
I had to type from console to so maintain formatting I put it on a
paste site:
https
Hello All
I have updated the gist with the correction and tried again this evening
but that error is still occurring.
Thanks
Jeff
On 14/02/13 09:06, Jeffrey Jones wrote:
Hi Devrim
Damn, sorry that was a typo, I had to manually copy the output, sorry.
Thanks
Jeff
On 14/02/13 01:08
really was a problem then I would have
expected sqliteman to fail reading the file.
Also: Is there a way to check the *actual* file that is downloaded by
yum itself?
cheers
Jeff
On 13/02/13 17:31, Jeffrey Jones wrote:
Actually, the URL for the meta-data file is right there in the error
Hi Stephen.
On 15/02/13 10:52, Stephen Frost wrote:
* Jeffrey Jones (jjo...@toppan-f.co.jp) wrote:
I downloaded
http://yum.postgresql.org/9.2/redhat/rhel-6Server-x86_64/repodata/primary.sqlite.bz2
using wget on the afected computer and ran md5sum over it with the
following result
ving a non-deterministic network.
Thanks for all the help.
Regards,
Jeff
On 15/02/13 10:52, Stephen Frost wrote:
* Jeffrey Jones (jjo...@toppan-f.co.jp) wrote:
I downloaded
http://yum.postgresql.org/9.2/redhat/rhel-6Server-x86_64/repodata/primary.sqlite.bz2
using wget on the afected computer and
suggestions would be appreciated.
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com <mailto:jsch...@iso.com>
This em
suggestions would be appreciated.
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com <mailto:jsch...@iso.com>
This em
Good Morning Laurenz,
That worked perfectly.
Thank You
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com
-Original
Why are there too many to fix with ALTER?
Use SQL and the data dictionary to generate the DDL and pipe it into
psql (or spool it to disk and use that file as a sql script):
psql your_db_name -t -c "select 'alter table '||t.tablename||' rename
\"'||c.column_name||'\" to '||lower(c.column_name)||
All right children. Recess is over, get back to work.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ed Koch
Sent: Wednesday, September 16, 2009 8:27 AM
To: 'mgai...@hotmail.com'; 'g...@seespotcode.net'
Cc: 'dmag...@gm
I've been tasked with a quick acceptance check of Postgres for an
upcoming project. It's a quick check, so its limited to Clang's
analyzer and sanitizers.
The analyzer is reporting some findings, and some of the findings look
legitimate.
For example, it looks like there's a double `free` occurrin
On Mon, Nov 11, 2013 at 2:00 AM, Tomas Vondra wrote:
>
>> Would someone know the best way to get this to the right folks?
>>
>> Thanks in advance. (And sorry reporting to pgsql-general - the
>> developer list states emails must go elsewhere first).
>
> IMHO pgsql-hackers is the right audience for
The following dropped out of `make check` for Postgres 9.3.1.
Any ideas how to clear the error? I could not locate answers when
searching the phrase.
Thanks in advance.
**
$ make check
...
mkdir ./testtablespace
../../../src/test/regress/pg_regress --inputdir=.
--temp-install=./tmp_che
Thanks Tom.
On Mon, Nov 11, 2013 at 8:51 PM, Tom Lane wrote:
> Jeffrey Walton writes:
>> The following dropped out of `make check` for Postgres 9.3.1.
>
> Sure you've got a complete source tree? There ought to be files in
> that directory:
>
> $ ls src/test/regre
On Mon, Nov 11, 2013 at 10:26 PM, Tom Lane wrote:
> Jeffrey Walton writes:
>> From below, I'm thinking --inputdir might not be quite correct. `mkdir
>> ./testtablespace` creates testtablespace in regress/, not input/. I'd
>> like to try --inputdir=./input/.
>
Hoover, Jeffrey would like to recall the message, "[GENERAL] Complicated GROUP
BY".
if criteria_1 and _2 are indexed:
select
mx.product,
p1.provider as best_provider_1,
mx.max_criteria_1,
p2.provider as best_provider_2
mx.max_criteria_2
from
(select
product,
max(criteria_1) as max_criteria_1,
max(criteria_2) as max_criteria_2
from
products_provi
This will also work as long as the table isn't large or product is
indexed.
actually,its more likely product is indexed that criteria_1 or _2...
Note: in this case when there is a tie one provider is arbitrarily
selected
select mx.product,
mx.max_criteria_1,
(select provider fro
minor refinement on suggestion:
-- CTAS (create table as) is easiest way to create table with same
structure
create table foo as select * from orig_table;
-- truncate is much more efficient than delete
truncate orig_table;
-- unchanged
insert into orig_table select * from foo;
-- recompute statist
change t.date2< dates.date to t.date2+0= dates.date) and t.date2+0mailto:[EMAIL PROTECTED] On Behalf Of Jeff Amiel
Sent: Thursday, September 25, 2008 10:24 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] The planner hates me.
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by GCC gcc (G
Anyone have some idea how to do this? I am able to install my Win32
application but the postgeSQL install will not work. Any help or at
least a starting point would be appreciated.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
On Mar 15, 7:23 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Mon, Mar 15, 2010 at 1:04 AM, Jeffrey Ottery
>
> wrote:
> > Anyone have some idea how to do this? I am able to install my Win32
> > application but the postgeSQL install will not work. Any help or at
> > leas
Running Windows XP Pro. Have been successfully using and deploying
postgres for 2 years.
When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
Programs I get this message:
Service "PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start.
Verify that you have sufficient privileges to
On Apr 9, 12:47 pm, cr...@postnewspapers.com.au (Craig Ringer) wrote:
> On 8/04/2010 2:01 PM, JeffreyOtterywrote:
>
> > Running Windows XP Pro. Have been successfully using and deploying
> > postgres for 2 years.
>
> > When I try to Uninstall PostgreSQL 8.3 using Windows Add/Remove
> > Programs I g
.
All help would be greatly appreciated.
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com <mailto:jsch...@iso.
Create a plpgsql function that reformats your row as an array.
Example:
I have a table named task_parameter with three columns:
Table "camera.task_parameter"
Column | Type | Modifiers
--+-
I have a table, queries, with a column value. There is a trigger on
this table that inserts into query_history for each update to value.
I'm trying to graph the query_history table, so I was using a custom
aggregate to turn it into an array:
CREATE AGGREGATE array_accum (anyelement)
(
sfunc = arr
re ignored. That's
fine, but
I need those options, how are they now accomplished with an existing
database
or a creation of a new database.
My assumption is that the java may be taken care of by the jbdc driver.
Any assistance is helpful.
TIA,
Jeffrey Trimble
System LIbrarian
William F
ib has the
libreadline.so.6, etc.
We are using readline 6.0 on Suse Linux 11. (kernel version:
2.6.27.21-0.1-pae)
Any ideas why configure is not able to find the readline.h when I am
telling where it is?
Thanks in advance.
--Jeff
Jeffrey Trimble
System LIbrarian
William F. Ma
e compiler isn't looking in the proper
directory.
Use --without-readline to disable readline support.
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
jtrim...@cc.ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ysu.edu
On May 19
d reference to `tgoto'
/usr/local/lib/libreadline.so: undefined reference to `tgetnum'
/usr/local/lib/libreadline.so: undefined reference to `BC'
/usr/local/lib/libreadline.so: undefined reference to `tgetstr'
collect2: ld returned 1 exit status
configure:6370: $? = 1
configure:
eadline 5.2 was installed during
the suse linux installation but it never installed the readline.h
file. Go figure.
--Jeff
Jeffrey Trimble
System LIbrarian
William F. Maag Library
Youngstown State University
330.941.2483 (Office)
jtrim...@cc.ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ys
Or
select date_part('day', date_trunc('month', '01/10/04') + '1
month'::interval - '1 day'::interval) as days;
or
select date_part('day', to_date('mon', 'Jan') + '1 month'::interval - '1
day'::interval) as days;
Arthur Hoogervorst wrote:
Hi,
Something like this?
SELECT date_part('day',
D A GERM wrote:
I have been trying to write an sql statement that returns the same
hours in a time stamp no matter what the date.
I can to pull same hours on the the same days but have not been able
to figure out how to pull all the same hours no matter what the date.
Here is the one sql stat
I think a better approach is to handle configuration management with a
table in each schema. Update the schema, update the table. This works
well with automating database upgrades as well, where upgrades are written
as scripts, and applied in a given order to upgrade a database from release
A
h Group at...
http://groups.yahoo.com/group/electrogravityresearch/
Much respect,
Jeffrey N. Cook
Start your day with Yahoo! - make it your home page
On Jul 30, 2005, at 2:30 PM, Jon Christian Ottersen wrote:We are trying to find a good way to document our database design – what is the rationale behind each table/field, what kind of information is each field supposed to contain, perhaps also something about the linking between the tables etc. Is
Greg Stark wrote:
Bruce Momjian writes:
Well, I just added to TODO:
* Allow VIEW/RULE recompilation when the underlying tables change
Is dynamic view a industry-standard name? If so, I will add it to the
TODO.
"DYNAMIC" is something I made up.
"ALTER VIEW RECOMPILE" is O
Neil Conway wrote:
"COUNT(*) very slow": this is a known issue -- see the -hackers archives
for many prior discussions. MVCC makes this hard to solve effectively
(whether applications should actually be using COUNT(*) on large tables
with no WHERE clause is another matter...)
-Neil
And it's
Joshua D. Drake wrote:
Bruce Momjian wrote:
Matthew Terenzio wrote:
As much as I respect Marc and Postgresql.org, I can't see Oracle
hiring him away as a "killer" threat to the community. People would
set up camp somewhere else, like Command Prompt. It would hurt
things for a while but t
On Oct 13, 2005, at 12:00 PM, Alex Turner wrote:
>
>Instance Manager: Uniquely MySQL. It allows things like starting
and
>stopping the database remotely.
>
>
I cannot think of a reason ever to need this when we have OpenSSH
I'm just curious, but how does this work for a windows bo
codeWarrior wrote:
SELECT trim(trailing ' ' from city_name) AS city_name FROM sys_cities;
You might consider reading the manual as there are a multitude of string
manipulation functions built into postgreSQL
You didn't answer his question. If you're going to rag on someone for
not read
Hopefully your pg_hba.conf files look more like:local all all trusthost all all 192.168.10.0/24 trusthost pgbench all
192.168.3.0/24 trustOn 27 Sep 2006 21:02:47 -0700, blackjadelin <
[EMAIL PROTECTED]> wrote:I have co
On 10/20/06, Jean-Christophe Roux <[EMAIL PROTECTED]> wrote:
Hello,[snip]
none
of them will be inserted because the first insert is a primary key
violation. How can I have postgreSQL not mind about the error and
proceed to the next insert. I could send the inserts one at a time but
bundling them
On 24 Nov 2006 04:43:02 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I just can't understand the use of this PGDATA variable!
-I am on FC3. (pgl 7.4)
-I am installing rpms and then running /etc/init.d/postgresql start
(which is done by default)
-The resulting "data" directory is in
On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
Not exactly. SQL Analyzer also includes live monitoring of whatever
queries are coming into the database. You can achieve something similar by
enabling query logging in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTE
I have not heard of such a thing for PostgreSQL, although I am
sure the basic information you want could be obtained from logging
queries and timing.
- Ian
On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of whatever
queries
&
How long has that been available for OS X? Last time I looked at it it
wasn't.
On 1/8/07, Dave Page <[EMAIL PROTECTED]> wrote:
> --- Original Message ---
> From: "Ian Harding" <[EMAIL PROTECTED]>
> To: "Jeffrey Melloy" <[EMAIL PRO
Not exactly. SQL Analyzer also includes live monitoring of whatever queries
are coming into the database. You can achieve something similar by enabling
query logging in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
There is no GUI tool that I know of, but there is EXPLAIN wh
On 1/30/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
This has been discussed about ten thousand times, and the answer is
still no.
How did we go from this?
To this:
It's already in the TODO list.
regards, tom lane
Perhaps we should be more diplomatic in our appr
On 4/11/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by s
On 4/11/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by s
If you want to return rows with zeros, you may need to do something like
this:
select b.name as viewer, count(viewerid)
from xenons b left join viewer_movies a on (b.id = a.viewerid)
group by b.name
Eddy Macnaghten wrote:
select b.name as viewer, count(*)
from viewer_movies a, xenons b
where b.id
it:
http://www.visualdistortion.org/misc/dont_do_this.png)
Jeffrey Melloy
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messa
Tom Lane wrote:
Jeffrey Melloy <[EMAIL PROTECTED]> writes:
I attempted to install 8.0 RC 2 alongside 7.4.5 on my OS X box, but
initdb failed with an error about not enough shared memory.
Don't forget that both shmmax and shmall may need attention ... and,
just to confuse matter
Ragnar Hafstað wrote:
On Wed, 2005-01-05 at 13:03 -0800, Jeff Davis wrote:
On Wed, 2005-01-05 at 13:14 -0700, Michael Fuhr wrote:
On Wed, Jan 05, 2005 at 08:15:28PM +0100, Joost Kraaijeveld wrote:
[snip]
PostgreSQL
doesn't have materialized views per se but it does have function
Chris wrote:
I know this isn't entirely postgresql specific, but it wouldn't be on
another list either so here goes...
I am writing an open source application where I would like to support
at least oracle, and possibly firebird or DB2, in addition to
postgresql which will be the default. I'm not g
This is a little vague...There is a way to recover the data. Make postmaster come back up. Unless you're talking about postmaster not coming up due to corrupted data files, or a hardware failure.You do need to use pg_dump at regular intervals. It is common practice to back up data, after all.
No
Mike Rylander wrote:
Mike Rylander wrote:
On 12/6/05, Marcus Engene <[EMAIL PROTECTED]> wrote:
[snip]
A & (B | (New OperatorTheNextWordMustFollow York))
Actually, I love that idea. Oleg, would it be possible to create a
tsquery operator that understands proximity?
Andrus Moor wrote:
I have a table containing month column in format mm.
create table months ( tmkuu c(7));
insert into months values ('01.2005');
insert into months values ('02.2005');
How to create select statement which converts this column to date type
containing last day of month like
Atomicity, Consistency, Isolation and DurabilitySee:http://cegt201.bradley.edu/projects/proj2003/equiprd/acid.html
On 1/5/06, John Meyer <[EMAIL PROTECTED]> wrote:
Okay, what exactly is ACID compliance?---(end of broadcast)---TIP 6: explain analyze is
Jimbo1 wrote:
Hello there,
I'm a freelance Oracle Developer by trade (can almost hear the boos now
;o)), and am looking into developing my own Snowboarding-related
website over the next few years. Anyway, I'm making some decisions now
about the site architecture, and the database I'm going to n
Patrick TJ McPhee wrote:
In article <[EMAIL PROTECTED]>,
Jim Nasby <[EMAIL PROTECTED]> wrote:
% Not sure if it's still true, but DB2 used to limit varchar to 255. I
% don't think anyone limits it lower than that.
Sybase: 254. Silently truncates.
IIRC, Oracle is 4096.
Jeff
---
Oscar Picasso wrote:
HI,
I would like to implement a search by distance to my application.
Something like (pseudo sql):
select * from users
where users.location is less than 15 miles from chicago.
Any documentation on how to implements that?
I guess I also need a database of the cities coor
Hello,
I'd like to write a C Function for Postgresql that can access data in
the database, use that to conduct additional queries to find more
information in the database and eventually return a result. I
currently have the functionality I want implemented as php/C programs
that first connect to
On 8/8/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Tue, Aug 08, 2006 at 12:16:18PM -0700, [EMAIL PROTECTED] wrote:
> I'd like to write a C Function for Postgresql that can access data in
> the database, use that to conduct additional queries to find more
> information in the database and event
I am trying to compile postgresql 7.4.1 for sco 5.0.5 and get the following error:
"thread.c", line 269: error: undefined symbol: h_errno
Any ideas?
./configure --with-libs=/usr/local/lib --with-includes=/usr/local/include
herbie!/tmp/postgresql-7.4.1 # gmake
gmake -C doc all
gmake[1]: Entering
hello
i have been used RH for over 5 yrs and some of our server are going to
RH AS and most of our workstations are moving to fedora
i have fedora servers in testing right now(PG 7.4 and 7.3) and have not
seen any major problems
as for extended rh9,7.. support you can check out
http://www.tummy.
Recently, I decided to rename one of my schemas from "adium" to "im".
Then, all inserts started failing.
I recreated a couple functions, changed the search path, and all inserts
are still failing due to referential integrity checks going against
"adium" still. Is there any way I can fix this, sh
Oleg Bartunov wrote:
Marcel,
it's very difficult from you message where do you lost.
pgsql version, OS version, cut'n paste of commands you run and
output would be fine.
To install tsearch2 most people need (as postgresql superuser):
1. install postgresql and headers
2. cd contrib/tsearch2
3. make;
I have a couple users trying to install Postgres on OS X. To the best
of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
errors while trying to init the database:
Reducing the shared buffers didn't help.
Any thoughts would be appreciated.
Jeffrey Melloy
[EMAIL PROT
Tom Lane wrote:
Jeffrey Melloy <[EMAIL PROTECTED]> writes:
I have a couple users trying to install Postgres on OS X. To the best
of my knowledge, both of them are using 7.4.5/10.3.5, and got identical
errors while trying to init the database:
They need to increase the system&#x
drop table A;
create table A (
id SERIAL PRIMARY KEY,
foo int default 5,
bar int default 10
);
insert into A (id, foo, bar) values (1, 1, 1);
insert into A (id, foo, bar) values (2, 2, 2);
insert into A (id, foo, bar) values (3, 3, 3);
insert into A (id, foo, bar) v
If you use a serial datatype, it simply says "the *default* behavior is
to use the next value of sequence a". So you can insert 1, 2,
10,204,492 into the column just fine. However, by inserting data into
something you want to auto-increment, you can run into non-uniqueness.
(Like you were).
It does if you look at the original email. Maksim must've just
transposed a couple letters when he was writing his demo.
Jeff
Kathy zhu wrote:
If it skips "-", then RMT-* should come before RM-V*, but they don't,
why ??
Maksim Likharev wrote:
en_US locale skips? punctuation from sorting in
If you don't mind spending a little money and are on Windows, you can
use Microsoft Visio Professional.
On Saturday, August 16, 2003, at 01:38 AM, Ron Johnson wrote:
On Thu, 2003-08-14 at 23:17, David Fetter wrote:
"Tim Edwards" <[EMAIL PROTECTED]> wrote:
I have been request to create a relati
I was recently running into performance problems with a query
containing now()::date or CURRENT_DATE. When I went to debug,
'now'::date made efficient use of the index (on a timestamp field).
The docs say that 'now' is turned into a constant right away. Is this
overhead/poor planning simpl
Hi,
I'll try to switch from Oracle to postgres for some small applications.
Is it possible to build functions like Oracle's nvl or decode with
pgplsql?
How can I make a function like nvl that works for every datatype?
Best regards,
Christian
Try coalesce. The syntax is the same as nvl.
Jeff
-
On Thursday, August 28, 2003, at 08:58 AM, Dennis Gearon wrote:
Heath Tanner wrote:
Not to take anything away from the books on the topic, but my
favorite source is the docs that got installed with postgres
(/usr/local/pgsql/doc/html).
The index isn't great, but easily overcome:
grep -i "sear
On Thursday, August 28, 2003, at 09:03 PM, Williams, Travis L, NEO
wrote:
I have a table1 with 2 col (a & b) where b can sometimes be null. I
need a query that if B is null I get back the contents of A.. but if B
is not null I do a "select d from table2 where d like '%b%'" There is
nothing to jo
If I'm understanding you correctly, you can do something like:
select cola,
colb,
exists
(select 'x'
from tableb
where colc = colb)
from tablea
Since that has a subselect, you may get better performance with
something li
On Thursday, October 9, 2003, at 01:42 AM, Shridhar Daithankar wrote:
[EMAIL PROTECTED] wrote:
One of my friend lost data with mysql yesterday.. The machine was
taken down for disk upgrade and mysql apperantly did not commit the
last insert.. OK he was using myisam but still..:-)
It sounds lik
I'm also interested, so could you post to the list?
Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
> -Original Message-
> From: David Reid [mailto:[EMAIL PROTECTED]]
> Sent: October 19, 2000 5:31 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] MySQL -> pgsql
I don't think this will work in all cases. The index syntax is different
between mysql and psql. For example, I specify indexing in the create
clause under mysql; I use a separate statement to create an index under
psql. Am I missing something?
Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
ideas for migration will be most appreciated.
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
> -Original Message-
> From: Michelle Murrain [mailto:[EMAIL PROTECTED]]
> Sent: October 19, 2000 3:15 PM
> To: Diehl, Jeffrey; David Reid
> Cc: [EMAIL P
But remember, that mysql doesn't have rules, triggers and such. Moving the
data is all I need to do. I guess I could write a tool to select from mysql
and insert into psql... I was hoping someone else had already done it. ;^)
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
[EMAIL PROTECTED]
MySQL -> pgsql
>
>
> On Thu, Oct 19, 2000 at 03:18:50PM -0600, Diehl, Jeffrey wrote:
> > The database I am hoping to migrate has a few tables with around 50K
> > records. These databases get updated every hour, 24/7. I
> don't think I can
> > do the migrat
Folks,
Will the lastest ODBC driver support Windows NT? The site for it seems
to indicate that it will only work with Windows 95. I have installed in
on a WinNT machine and it reports that the user cannot log in and that
the authentication type is unknown.
Suggestions?
Thanks,
Jeffrey Lyon
1 - 100 of 124 matches
Mail list logo
