I have a very primitive question about division to which I can’t find an
obvious answer in the documentation.
Given two values defined as integers, how do I divide one by the other and get
an answer with two decimals, e.g 3 /4 = 0.75.
This is very simple in mysql and seems to be oddly contorted
.
From: "David G. Johnston"
Date: Wednesday, March 7, 2018 at 11:23 AM
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org"
Subject: Re: a very primitive question about division
On Wed, Mar 7, 2018 at 10:21 AM, Martin Mueller
mailto:martinmuel...@northwestern.edu>&g
progressed much beyond
8th grade math.
From: "David G. Johnston"
Date: Wednesday, March 7, 2018 at 11:43 AM
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org"
Subject: Re: a very primitive question about division
On Wed, Mar 7, 2018 at 10:30 AM, Martin Muelle
about the problem of
decimals in division, together with an example of how to do 4/9 in different
formats, and a reference to the fuller discussion.
From: "David G. Johnston"
Date: Wednesday, March 7, 2018 at 12:11 PM
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org&q
value.
Is there a way of doing this in a single-step procedure or can you chain the
two parts together in one query? This goes beyond my SQL competence.
Martin Mueller
I made a stupid mistake with a backup and would be grateful for some advice on
how to extricate myself.
I created a dumpfile from a 10.3 postgres installation on a Mac and tried to
restore it on another Mac 1,000 miles away, but forgot that that machine runs
Postgres 9.6.
The command
/Applica
Many thanks for your generous help, and on a Sunday afternoon as well.
This is a wonderful listserv, and I am deeply indebted to it.
MM
On 7/15/18, 2:17 PM, "Tom Lane" wrote:
Martin Mueller writes:
> I created a dumpfile from a 10.3 postgres installation on a Mac
I have followed this list for a couple of years, have benefited several times
from quick and helpful advice, and wonder whether all this code of conduct
stuff is a solution in search of a problem. Or, if there is a problem now and
then, whether an elaborate code does a better job than reminding
On 9/14/18, 12:50 PM, "Joshua D. Drake" wrote:
On 09/14/2018 07:41 AM, James Keener wrote:
> > Community is people who joined it
>
> We're not a "community."
I do not think you are going to get very many people on board with that
argument. As anyone who knows me w
What counts as foul language has changed a great deal in the last two decades.
You could always tie it to what is printable in the New York Times, but that
too is changing. I could live with something like “Be considerate, and if you
can’t be nice, be at least civil”.
From: Melvin Davidson
Da
again "Where is the problem that needs solving?"
On 9/15/18, 11:32 AM, "Bruce Momjian" wrote:
On Sat, Sep 15, 2018 at 04:24:38PM +, Martin Mueller wrote:
> What counts as foul language has changed a great deal in the last two
decades.
> You coul
As long as subscribers to the list or attendants at a conference do not violate
explicit or implicit house rules, what business does Postgres have worrying
about what they do or say elsewhere? Some version of an 'all-of-life' clause
may be appropriate to the Marines or federal judges, but it s
I’ve looked at the documentation to find where to find some data that are very
to find Mysql: the creation and modification data of a table and the size of
particular tables.
Where do I find an answer to the question “which is the last table I created”
or “when did I last modify this table?”
I created a primary key with the following commands
Add id serial
Add primary key (id)
I cannot figure out from the documentation how to drop that column.
ified table. Which is
really useful if you have a bad memory, as I do, and can't remember the name of
a particular table that I worked on last Wednesday.
Are those capabilities hidden somewhere in Postgres? There isn't an obvious
section in the documentation. At least I can't find
Leaving aside the question of money, a frontend like AquaData Studio or the
equivalent program by Jetbrains would be a much better solution. I used to work
with Access a lot and quite liked it. But AquaData Studio is not any more
difficult to learn and gives you access to everything Postgress ca
On the topic of what other databases do better: I much prefer Postgres to Mysql
because it has better string functions and better as well as very courteous
error messages. But MySQL has one feature that sometimes makes me want to
return it: it stores the most important metadata about tables in a
I have used Aqua Data Studio for several years. Jetbrains recently released a
similar product. Academic licensing is affordable (~ $200 a year) and very
cheap if considered in terms of the time it saves you.
From: David Gauthier
Date: Tuesday, October 30, 2018 at 2:06 PM
To: "pgsql-gene...@post
Functions. But there isn’t.
The documentation of string functions is exemplary. The documentation of
mathematical less so. Remember that it may be used by folks like me whose math
is shaky. The MySQL documentation is better on this simple operation.
-
Martin Mueller
Professor emeritus of
I didn't formulate my question properly, because the query went like
"select alldefects /wordcount"
where alldefects and wordcount are integers. But none of the different ways
of putting the double colon seemed to work.
The Postgres notation of this simple procedure is very unintuitive. I ha
e. If you didn't know the root form, the dictionary was
no use.
In this, single stop shopping for the three most common problems of simple
division makes life easier for users.
On 12/4/18, 3:06 PM, "David G. Johnston" wrote:
On Tue, Dec 4, 2018 at 1:57 PM Martin Muell
I take the point that two decades of backward compatibility should and will
win. That said, it's an easy enough thing to right the balance for novices and
put in a really obvious place in the documentation what you should do if you
want to divide two integers and get the results with the number
EXTENSION IF NOT EXISTS tablefunc;
but it did nothing. It doesn’t seem to work as import statements in Python do
-
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
26/19, 8:04 PM, "Adrian Klaver" wrote:
On 2/26/19 5:51 PM, Martin Mueller wrote:
> I run Postgres 10.5. I understand that there is something called
> tablefunc and it includes a crosstab function. On Stack Overflow I learn
> that you import this function. But
ment, which handles up to 10 million rows quite
comfortably.
A I right in thinking that given my tasks and equipment it would be a waste of
time to update? Or is there something I’m missing?
Martin Mueller
Professor emeritus of English and Classiccs
Northwestern University
I currently work with Postgres 13. I forgot to mention that. From which I
gather that around version 18 it would be time to upgrade. But in the interim
I’d be OK.
Right?
From: Adrian Klaver
Date: Thursday, May 18, 2023 at 11:21 PM
To: Martin Mueller ,
pgsql-general@lists.postgresql.org
I have a very stupid password question. I don’t know whether a postgres
database on my Mac has a pass word or not.
I access the database via the Aqua Data Studio frontend as the user postgres. I
don’t think I ever added a password, and on the authentication panel the
password box is empty but t
data via Aqua Data Studio, as if they were very large spreadsheets.
Is that a correct analysis? I just want to make sure.
Martin Mueller
Professor emeritus of English and Classsics
Northwestern University
Are there performance issues with the choice of 'text' vs. varchar and some
character limit? For instance, if I have a table with ten million records and
text fields that may range in length from 15 to 150, can I expect a measurable
improvement in response time for using varchar(150) or will t
mapping and how can I query it? On what page of the
documentation do I find the answer?
I much prefer Postgres to Mysql for a variety of reasons, but mostly for its
elegant string functions. But in Mysql it seems to be much easier to keep track
of tables.
Martin Mueller
Professor emeritus of
table
that I know as ‘earlyprinttuples
With thanks in advance for any advice
Martin Mueller
Professor emeritus of English and Classics
Are there rules for thumb for deciding when you can dump a whole database and
when you’d be better off dumping groups of tables? I have a database that has
around 100 tables, some of them quite large, and right now the data directory
is well over 100GB. My hunch is that I should divide and conqu
To: Martin Mueller
Cc: "pgsql-general@lists.postgresql.org"
Subject: Re: a back up question
On Tue, Dec 5, 2017 at 2:52 PM, Martin Mueller
mailto:martinmuel...@northwestern.edu>> wrote:
Are there rules for thumb for deciding when you can dump a whole database and
when you’d be be
On 12/6/17, 4:39 AM, "karsten.hilb...@gmx.net" wrote:
On Tue, Dec 05, 2017 at 09:52:28PM +0000, Martin Mueller wrote:
> Are there rules for thumb for deciding when you can dump a
> whole database and when you’d be better off dumping groups of
> tables?
intelligible to others
like me, and there may be some.
With thanks in advance
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
I get this error message:
table tid from new index tuple (32586,21) overlaps with invalid duplicate tuple
at offset 120 of block 4398 in index "aacorrections_tcpreading_idx"
from an update query of the
update table 1 set columnx = ‘yes’
where table1.xmlid in (select xmlid from table2)
I have no
36 matches
Mail list logo
