On 3/7/14, RSmith wrote:
> Add to this the fact that you can - through SQL's ability to add
> user-defined functions (an almost unique ability among SQL engines)
Is that really so? I thought most sql engines had that. You can
define functions in at least postgreSQL:
http://www.postgresql.o
On Thu, Mar 6, 2014 at 8:41 PM, RSmith wrote:
>
> On 2014/03/07 01:59, Gabor Grothendieck wrote:
>>
>>
>>>
> A small enhancement request:
>
> It would be great if the RPAD and LPAD functions could be implemented
> in
> sqlite.
>
The SQLite you can get the effect o
On 2014/03/07 01:59, Gabor Grothendieck wrote:
A small enhancement request:
It would be great if the RPAD and LPAD functions could be implemented in
sqlite.
The SQLite you can get the effect of RPAD(x,y) using PRINTF('%-*s',y,x).
See http://www.sqlite.org/lang_corefunc.html#printf for d
On Thu, Mar 6, 2014 at 6:29 PM, Walter Hurry wrote:
> Richard Hipp wrote:
>
>> On Thu, Mar 6, 2014 at 3:41 PM, Walter Hurry wrote:
>>
>>> A small enhancement request:
>>>
>>> It would be great if the RPAD and LPAD functions could be implemented in
>>> sqlite.
>>>
>>
>> The SQLite you can get the
On Wed, 5 Mar 2014 22:41:47 -0800 (PST), SARC
wrote:
> Hi,
> I am using sqlLite administrator interface(0.8.3.2 public beta) in my
> windows XP PC. I am setting default value for some of columns(text,integer)
> in my table(like 0,'none' etc). But it seems some quotation marks will be
> added arou
Richard Hipp wrote:
> On Thu, Mar 6, 2014 at 3:41 PM, Walter Hurry wrote:
>
>> A small enhancement request:
>>
>> It would be great if the RPAD and LPAD functions could be implemented in
>> sqlite.
>>
>
> The SQLite you can get the effect of RPAD(x,y) using PRINTF('%-*s',y,x).
> See http://www.sq
2014-03-06 22:02 GMT+01:00 Larry Brasfield :
> This makes Cygwin unique among all operating systems with which I am
> familiar having support for hierarchical filesystems. Most importantly, if
> true, it would differ from Unixen. I suggest that, in fact, bare
> filenames, (names without any prepe
Jan Nijtmans wrote, in part, re Cygwin :
*> *bare filenames are NOT expected to be found in the current directory
This makes Cygwin unique among all operating systems with which I am
familiar having support for hierarchical filesystems. Most importantly, if
true, it would differ from Unixen. I s
On Thu, Mar 6, 2014 at 3:41 PM, Walter Hurry wrote:
> A small enhancement request:
>
> It would be great if the RPAD and LPAD functions could be implemented in
> sqlite.
>
The SQLite you can get the effect of RPAD(x,y) using PRINTF('%-*s',y,x).
See http://www.sqlite.org/lang_corefunc.html#printf
A small enhancement request:
It would be great if the RPAD and LPAD functions could be implemented in sqlite.
I know I can easily achieve the equivalent by concatenating and TRUNCing, but
if the functions were available natively it would avoid the need to hack third
party SQL scripts.
Dr. Hipp
On 2014/03/06 18:41, Tilsley, Jerry M. wrote:
I would like to create the following INSTEAD OF INSERT trigger:
create trigger insteadInsertPanelTracker instead of insert on
panel_tracker begin set @ov_id = select ov_id from ov_systems where
mt_mnemonic=NEW.ov_id; insert into panel_tracker values
>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
>On Behalf Of Clemens Ladisch
>Sent: Thursday, March 06, 2014 11:29 AM
>To: sqlite-users@sqlite.org
>Subject: Re: [sqlite] Instead Of Insert Trigger Error
>Tilsley, Jerry M. wrote:
>> I h
Tilsley, Jerry M. wrote:
> I have the schema:
> CREATE TABLE panel_tracker (ov_id numeric, mt_acct char(12), orm_id numeric,
> panel_code char(5));
Really? You don't have a "ov_systems" table?
> I would like to create the following INSTEAD OF INSERT trigger:
> create trigger insteadInsertPanelT
All,
I have the schema:
CREATE TABLE panel_tracker (ov_id numeric, mt_acct char(12), orm_id numeric,
panel_code char(5));
I would like to create the following INSTEAD OF INSERT trigger:
create trigger insteadInsertPanelTracker instead of insert on panel_tracker
begin
set @ov_id = select ov_id fr
Thank you Joe,
Awesome work guys!
--
Thanks,
Denis Gladkikh
http://outcoldman.com
On Wed, Mar 5, 2014 at 7:03 PM, Joe Mistachkin wrote:
>
> Denis Gladkikh wrote:
> >
> > I still have this issue with SQLite 3.8.3.1, I could fix my case my
> > changing line
> >
> > "LastPlayed] = (select case whe
http://www.sqlite.org/c3ref/c_source_id.html says
[...] SQLite version in the format "X.Y.Z" [...]
yet shows "3.8.3.1" and later says that SQLITE_VERSION_NUMBER is
computed using (X*100 + Y*1000 + Z), thus ignoring the last
version component. (SQLITE_VERSION_NUMBER = 3008003 is compatible wi
Hi,
I am using sqlLite administrator interface(0.8.3.2 public beta) in my
windows XP PC. I am setting default value for some of columns(text,integer)
in my table(like 0,'none' etc). But it seems some quotation marks will be
added around the default values after i do some editing to the table each
t
>And as far as I know, even the most expensive hardware RAID controllers
>and disks do not yet support multi-disk transactions, so your reference
>to not-yet existing hardware is moot.
They all do, unless the I/O was designed by a moron. Of course, morons are the
most plentiful element in the u
2014-03-05 17:07 GMT+01:00 Richard Hipp :
> A number of bugs have recently been revealed in SQLite. All are obscure.
> Nevertheless, we want to accelerate the release of version 3.8.4 in order
> to get the fixes in circulation.
Great, I'm looking forward to this! One of the bugs recently
discove
Hello,
Wouldn't it be a good idea, for the "windows" download version, to propose
also (or only) the "-o2 compiled" .dll and .exe versions ?
(trading 300Ko of executable size for a 50% speed-up is a bargain, when you
have a pc)
If the embedded developpers re-compile anyway from source to get the
20 matches
Mail list logo
