As you can read on the website you linked, a Free PostgreSQL database is limited to 10K (ten thousand) rows. The free “Sandbox” MongoDB option has no document limit, but a size limit of 496 MB. A single MongoDB document can be anywhere between a few bytes and 16MB. 2 solved What is the maximum … Read more
These type of queries are easier to make with an aim of GROUP BY, like this: Select case when profile.foo ~* ‘5.0.2195’ then ‘Win2k’ when profile.foo ~* ‘5.1.2600’ then ‘WinXP’ when profile.foo ~* ‘5.2.3790’ then ‘W2k3’ when (profile.foo ~* ‘6.0.6000’ or profile.foo ~* ‘6.0.6001’ or profile.foo ~* ‘6.0.6002’) then ‘Vista’ when (profile.foo ~* ‘6.1.7600’ or … Read more
First statement returns two rows, one for each array. select jsonb_array_elements(msg->’root’) as el from js Then returns each individual values as text. with aa as ( select jsonb_array_elements(msg->’root’) as el from js ) select jsonb_array_elements(el)->>’cid’ as cid, jsonb_array_elements(el)->>’Display’ as Display, jsonb_array_elements(el)->>’FName’ as FName, jsonb_array_elements(el)->>’LName’ as LName from aa; This returns 3rd element of 2nd array … Read more
With Oracle, you can store arrays in a column using NESTED TABLEs (or VARRAYs): SQL Fiddle Oracle 11g R2 Schema Setup: CREATE TYPE String_Table IS TABLE OF VARCHAR2(100) / CREATE TABLE test ( id NUMBER(10,0), col1 VARCHAR2(10), array1 String_Table ) NESTED TABLE array1 STORE AS test__array1 / INSERT INTO test ( id, col1, array1 ) … Read more
Your error is on line 73: birthyear = Integer.parseInt(request.getParameter(“birthyear”)); I’m guessing by your code that the form in the doGet function is the form posting the data you want to store in your database. Your form doesn’t contain a birthyear field. Its absence makes request.getParameter(“birthyear”) return null, which causes a NullPointerException when trying to parse … Read more
Just make it one: create function ops() returns table (region varchar, man integer, woman integer, test integer) as $$ Select region,man, woman, Case When woman > man then woman – man When woman < man then man – woman ELSE 0 END AS test From people; $$ language sql; 0 solved Postgresql switch query to … Read more
I got this fixed by creating a PHP function to return the latest thread with a SELECT * FROM threads WHERE subcat_id = variable SQL. 1 solved Resulting data on last thread_date
You can ask the database to secure your table and column names, using quote_ident(), before you create the query you want to execute. You need something like this: <?php $table=”table name”; // unsafe $column = ‘column name’; // unsafe $result = pg_query_params($connection, ‘SELECT quote_ident(CAST($1 AS text)), quote_ident(CAST($2 AS text));’, array($table, $column) ); $table = pg_fetch_result($result, … Read more
You can generate all starts of months with generate_series(), then bring the table with a left join: select to_char(d.start_date, ‘mon’) as month, extract(month from d.start_date) as month_num, sum(cost_planned) filter (where t.aasm_state in (‘open’, ‘planned’ ) ) as planned, sum(cost_actual) filter (where t.aasm_state=”closed”) as actual from generate_series(‘2020-01-01’::date, ‘2020-12-01’::date, ‘1 month’) d(start_date) left join activity_tasks t on … Read more
If it’s an ordinary transactional database, you can go for a data warehousing solution for your reporting purposes. Data warehouses are usually more efficient in these type of situations. solved Database growth – How to handle with big tables [closed]
Well you are on your with the last comment creating a Foreign Key. So we have a relationship between Customers and Contacts. However the outstanding question becomes what type is Customer:Contact relationship? One-to-One (1:1) -> Each Customer has one contact and a Contact is for one customer. One-to-Many (1:M) -> Each Customer has many contacts … Read more
So after a few days of trying everything, I just gave up on strongloop and tried using Retrofit2. Turns out everything works perfectly now. Thanks again @Signo for you time! Quite a frustrating ending, but I think as you said, it was probably not provided the right request and I guess the fact that it … Read more
On SQL-Server use CHARINDEX CHARINDEX ( expressionToFind , expressionToSearch [ , start_location ] ) DECLARE @CAMPO30 varchar(64) = ‘2,663.25’; SELECT CASE WHEN CHARINDEX(‘.’, @CAMPO30) > 1 THEN CAST(REPLACE(REPLACE(@CAMPO30,’.’,”),’,’,’.’) AS FLOAT) ELSE CAST(REPLACE(@CAMPO30,’,’,’.’) AS FLOAT) END AS CAMPO30 GO | CAMPO30 | | ——: | | 2.66325 | dbfiddle here 1 solved I need to convert … Read more
Writing something to a storage will prevent all other threads from writing to the same. You cannot simply make everything multithreaded. In this case all other parts Need to wait for the previous one to finish. solved load the data from file using multi threading
Based upon your question, it is a simple select distinct and then an order by SELECT distinct(Column_Name) FROM Table_name ORDER BY Column_Name DESC Or SELECT distinct(Column_Name) FROM Table_name ORDER BY Column_Name Depending on the Sort order that you want 4 solved List ocurrences in column – SQL