23 1998 MSK becomes
26-11-1998) so the date_trunc masking is not quite what I'm looking for.
Would it be possible to do a select datetime and then output only the
dateday, datemonth and dateyear using an RE??
All the same, thanks for your suggestion Anatoly, UNION's the winner so far ;
s the cause. The code could not handle an AS with multiple
>words, because of the way it was stored in the rewrite system. This
>patch should fix the problem.
>
>Does it fix your second problem too?
>
>? src/Makefile.custom
>...patch follows...
+-
g tables as
Herouth suggested).
+-+------+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ University College London|
| Tel. (0171) 878 4041| 91 Riding House Street |
| Fax. (0171) 878 4040| Lo
Stuart.
PS. That leaves me with giving tables and fields smaller names... I
suppose names of over 31 are pretty silly anyway... no wonder I keep
exceeding the query buffer!!
+-+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
|
-in fact- just have pg 6.4 installed or is
PG_VERSION the same for 6.4 and 6.4.1?
+-+----------+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ 91 Riding House Street |
| Tel. (0171
vu d'article en francais
>:-)
>
Moi non plus mais maintenant ca fait trois (et presque une habitude) ;)
amicalement,
S.
+-----+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ 91 Ri
C++ compiler or just
that if you don't have a C++ compiler, you need to change your config flags
appropriately and lose some of the functionality?
regards,
Stuart.
+-----+--+
| Stuart Rison| Ludwig Institute for Cancer Rese
views.
I'm running PG 6.4.0.
regards,
Stuart.
+-----+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ 91 Riding House Street |
| Tel. (0171) 878 4041| London, W1P 8BT, UNITED KINGDOM. |
| Fax. (0171) 878 4040| [EMAIL PROTECTED] |
+-+--+
tware tools that people use to create entity
>relationship diagrams
>and to document databases?
>
>Thanks,
>
>Sarah Officer
>[EMAIL PROTECTED]
+-+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
+
suggestions on how to get the concatenation to work?
Also, I'm hoping to eventually concatenate an int4 field to the other two
so, having solved the above problem, how would I tackle that one?
Regards,
S.
+-+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ 91 Riding House Street |
| Tel. (0171) 878 4041| London, W1P 8BT, UNITED KINGDOM. |
| Fax. (0171) 878 4040| [EMAIL PROTECTED] |
+-+--+
| arm::varchar as locus from experiment;
but the solution is clearly in some form of casting!
I'm using PG 6.4, perhaps it's a version thing?
regards,
S.
+-+--+
| Stuart Rison| Ludwig Institute for Cancer Re
o defined in
archive
/usr/lib/ar: Warning:ignoring second definition of fmgr_pl_finfo defined in
archive
Result I thought, until I tried gmake install:
merlin::root 1# gmake install
plpgsql not installed due to lack of shared library support.
What do I try next? (Irix 5.3, psSQL 6.4)
t;> sturctures, variable assignment, and the like.
>>
>> >From simple to very complex, send anything that might be helpful.
>>
>> thanks a ton
>>
>> mike haberman
>> [EMAIL PROTECTED]
>>
>> >
>> >
>
>-
so, can
someone give me the point_out source to work with?
(I don't program in C -hell, I don't really program in anything, I dabble-
but I'm quite happy to experiment)
Regards,
Stuart.
+-+----------+
| Stuart Rison
ows)
HELP!
WHAT'S GOING ON!!!
Why can't I get to pt->y?
Why does function pants behave just like get_x (and get_y)?
Stuart.
+-+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
+---
w the rows are built up? Pardon for novice
>nature of this question...
>
>Thanks in advance,
>
>Anja
+-+--+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ 91 Riding House Street
scores are all entered in scientific notation.
>From experimentation, the smallest value I seem to be able to enter is
around 2.225e-308. Is this 'correct'?
This is PG 6.4 compiled with cc under Irix 5.3.
Cheers,
Stuart.
+-+------
rom extensive gnashing!
S.
+-+------+
| Stuart Rison| Ludwig Institute for Cancer Research |
+-+ 91 Riding House Street |
| Tel. (0171) 878 4041| London, W1P 8BT, UNITED KINGDOM. |
| Fax. (0
please specify what version of PG might have this
functionality... also, can anybody offer hints as to how to implement such
functionality if necessary?
Regards,
Stuart.
+-+--+
| Stuart Rison| Ludwig Institute for Cancer
At 6:53 pm +0300 4/8/99, Herouth Maoz wrote:
>At 17:32 +0300 on 04/08/1999, Clark C. Evans wrote:
>
>
>> I don't get image #2 "Leave's em big" could
>> someone explain this one? Also, having the version
>> number on the T-Shirt kinda dates it...
>
>I think you're right. And I thought that "l
Hi,
To the best of my knowledge, still no way of droping a field directly by
using ALTER.
Usual trick is to do something like:
SELECT
INTO temp_table
FROM ;
DROP TABLE ;
ALTER TABLE temp_table RENAME TO ;
But bear in my that:
- this will not preserve oid's...
- I think things like RULES
>> There is a COPY command that you can use...there is a man page for it,
>> sorry, don't use it myself, so dont know the syntax.
Then some bit about usually using Perl because of trouble getting COPY to
perform exactly right and then having to pay the price with slow inserts
instead of fast COPY
Hi,
>after an installation of PostgrSQL v6.5 on a new machine
>i have problems with a view which is running without problems
>under 6.4.x.
>But the view isn't the problem. The same statement on the real table
>realized the same error:
>ERROR: illegal use of aggregate or non-group column in target
At 8:38 am +0200 26/8/99, Jens Felber wrote:
>At 18:02 25.08.99 +0200, dpeder wrote:
>>have You set any triggers, rules, listens or defaults for tablex?
>>
>
>
>Nothing is set. I create a new table for tests.
>
> --> create table test1 (x1 int2, x2 int2, tx char);
>
>then I've inserted some values
don't know about any facilities to generate C files describing table
structure.
As to obtaining that information, I would say it is all in system catalog
tables (i.e. the tables that start with pg_ and which can be listed with
\dS in psql).
These are the tables that are queried when you use such
At 9:41 am -0700 31/8/99, Mark Dalphin wrote:
>Hi,
>
>Is there a way to display user-defined functions? For example, if I define a
>function using PL/pgsql, what tables do I query and in what way to learn that
>the function exisits and further, what its defintion is? I can find functions
>that re
On Fri, 10 Sep 1999, Tom Lane wrote:
> Stuart Rison <[EMAIL PROTECTED]> writes:
> > Now this would work except that there's a problem with pl/pgSQL such that
> > when you pass several values to a plpgsql function and one of them is
> > NULL, then all values pa
ms with
> dupplication errors! )
Precicely, this seems to be the general concensus, I need to have some
non-NULL empty value token.
Thanks to everybody who e-mailed help/suggestions.
regards,
S.
>
> >From: "Jackson, DeJuan" <[EMAIL PROTECTED]>
> >To
AFAIK, you can add and and rename columns no problem:
functions=> \h alter table
Command: alter table
Description: add/rename attributes, rename tables
Syntax:
ALTER TABLE class_name [*] ADD COLUMN attr type
ALTER TABLE class_name [*] RENAME [COLUMN] attr1 TO attr2
ALTER T
Hello,
Since I am going to do the very same upgrade in the near future, I'd be
very grateful if you could send a brief posting on how you
resolved that problem (and indeed any other you encountered during the
upgrade).
Regards,
S.
On Thu, 23 Sep 1999, Sebestyen Zoltan wrote:
> Since then, I s
looks like to index doesn't like to use functions which aren't internal.
In your case though, this is not a problem. Rather than defining function
'myupper' use the internal upper directly in the create index statement:
DROP INDEX upper_name;
CREATE INDEX upper_name ON prosb (upper(defendant_nam
On Thu, 9 Dec 1999, Dev Elop wrote:
> > >
> > > After an INSERT, I want to retrieve the value of the sequence I use for
> > > unique_ids
> > >
> ...
> >
> > Alternatively, use the currval(mytable_id_seq) function within the same
> > session immediately after the insert.
> >
> With this second met
32 matches
Mail list logo
