[sqlite] Selecting multiple similar columnname.

The GNSS systems do of course know when leap seconds occur, one of their purposes is to communicate accurately UTC. But unlike system clocks of computers which often are halted during leap seconds or slowed down before them, to avoid complications, the satellites will transmit their codes strictly

Re: [sqlite] Selecting multiple similar columnname.

volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Wout Mertens >Sent: Saturday, 9 June, 2018 06:22 >To: SQLite mailing list >Subject: Re: [sqlite] Selecting multiple similar columnname. > >So the

Re: [sqlite] Selecting multiple similar columnname.

So the satellites don't get leapsecond updates? I don't understand why it can't just be an epoch… On Sat, Jun 9, 2018, 8:39 AM Stephan Buchert wrote: > To take care of the leap seconds every ~1.5 years or so, you need a day > segmented time stamp and a three column primary key: > > CREATE TABLE

[sqlite] Selecting multiple similar columnname.

To take care of the leap seconds every ~1.5 years or so, you need a day segmented time stamp and a three column primary key: CREATE TABLE satlog ( sat INTEGER, day2000 INTEGER, -- days since 2000-01-01 msec INTEGER, -- milliseconds of day, just in case we ever have to deal with subs

Re: [sqlite] Selecting multiple similar columnname.

I forgot to add, if you do change the schema as advised, the query you wanted will become the very easy: SELECT SatNum FROM SatLog WHERE SNR > 30; Which will return one or more satellites as rows, or you can do as Gunter suggested: SELECT group_concat(SatNum, '; ') FROM SatLog WHERE SNR > 30

Re: [sqlite] Selecting multiple similar columnname.

On 2018/06/08 12:52 PM, Mukesh Kumar wrote: Hi Ryan, Thanks for the advice. I cant share the exact Schema, however i can give an idea. I am trying to store GNSS satellite info, which is streaming every second. My Primary Key is the Timestamp at which i have got the information.. And other colu

Re: [sqlite] Selecting multiple similar columnname.

SQLite mailing list Sent: Friday, June 8, 2018, 12:52:58 Subject: [sqlite] Selecting multiple similar columnname. Hi Ryan, Thanks for the advice. I cant share the exact Schema, however i can give an idea. I am trying to store GNSS satellite info, which is streaming every second. My Primary Key is

Re: [sqlite] Selecting multiple similar columnname.

Hi Ryan, Thanks for the advice. I cant share the exact Schema, however i can give an idea. I am trying to store GNSS satellite info, which is streaming every second. My Primary Key is the Timestamp at which i have got the information.. And other columns in the table are the satellite information

Re: [sqlite] Selecting multiple similar columnname.

On 2018/06/07 6:11 PM, mukeshkb4u wrote: Hi All, I have a table with multiple similar column names, like abc_1,abc_2,abc_3... Is there a way i can do a select on only these columns in a table, without specifiying the full column list? Can i use a regular expression in selecting column name

Re: [sqlite] Selecting multiple similar columnname.

On 7 Jun 2018, at 5:11pm, mukeshkb4u wrote: > I have a table with multiple similar column names, like > abc_1,abc_2,abc_3... > > Is there a way i can do a select on only these columns in a table, without > specifiying the full column list? > Can i use a regular expression in selecting colum

[sqlite] Selecting multiple similar columnname.

Hi All, I have a table with multiple similar column names, like abc_1,abc_2,abc_3... Is there a way i can do a select on only these columns in a table, without specifiying the full column list? Can i use a regular expression in selecting column names ? Regards Mukesh -- Sent from: http://