Join sailors with reserves, filter out rows before 2011-02-04, group by sailor and take only those results having a count over two. Translate this to SQL, and you are done. solved Can you provide a query for this question? [closed]
There are no built-in features to limit numeric values in the described manner. You can create and use a function to implement this behavior: create or replace function limited_numeric(val numeric, prec int, scale int) returns numeric language sql immutable as $$ select least(mx, val) from ( select format(‘%s.%s’, repeat(‘9’, prec- scale), repeat(‘9’, scale))::numeric as mx … Read more
Check pg_hba.conf for allowed hosts for connection. Under VPN you obviously have another IP then in local network. solved Hibernate connection with postgresql on vps not working
It looks like you tried to create your own JSON serializer, instead of using the one that comes with Ruby. Or, perhaps you didn’t realize that JSON was a thing and wanted to store arrays of hashes and tried to invent your own. Either way, it wasn’t a good path to follow. This is your … Read more
select id, column_1, column_2, case when id in (12,22,456,56) then 1 else 0 end as zzz from tablename The IN clause in the case statement can be replaced with a table name having those id’s like: select id, column_1, column_2, case when id in (select distinct id from table2) then 1 else 0 end as … Read more
Here I address you questions: 1. Any way to check the size of existing databases in CloudSQL instances? Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql) For mysql, you can run: SELECT table_schema “DB Name”, ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM … Read more
I can see what you’re after although there is a big omission: What happens when the status has reached ‘Z’ and it is time to update? More on that later. Your request has 2 components, actually getting a process to run and a rolling update procedure (script) for the status. Well, Postgres has no native … Read more
Introduction Write an introduction on Get a list of requests Solution Code Solution Get a list of requests with maxes as (select client_id, max(calls.call_datetime) latest_call from calls group by client_id) select tasks.client_id, title from tasks inner join maxes on maxes.client_id = tasks.client_id where created_datetime > maxes.latest_call If I understood correctly, this should be it 0 … Read more
To run schedule tasks on server use cron. With cron you can run php file that will read data from database and send email. solved A PHP platform to post messages on specific date [closed]
Use string_to_array to split the string into multiple elements that can be accessed individually: select rules[1] as rule_1, rules[2] as rule_2, rules[3] as rule_3, rules[4] as rule_4, rules[5] as rule_5, rules[6] as rule_6 from ( select string_to_array(rules, ‘|’) as rules from rulebook ) t 1 solved PostgreSQL query to split based on Strings & Concatenate … Read more
I ended up subquerying with this in the SELECT — cast(substring(column FROM ‘[0-9]+’) as int) and this in the WHERE column ~ ‘^\d+$’ in the FROM as its own table. Pulling just the integers i needed from that with IN (1,2,3) solved Pull specific numbers from a column that has numbers and words
What exactly you want to count? Only consumed? Or consumed by goal? If the second option, you need group by statment. SELECT count(consumed) as count FROM (some select) alias Or SELECT count(consumed) as count, goal FROM (some select) alias Group by goal solved COUNT and GROUP BY doesn’t works as expected [closed]
pgr_drivingDistance uses the cost value you provide, and in the units you implicitly specify, meaning that when you add a column <traveling_time> (note that I use seconds in my example) as the time needed to traverse an edge (given the length and speed limit) and select that as cost, the functions result will represent the … Read more
It looks like broken file – some problems can be enforced by BOM http://en.wikipedia.org/wiki/Byte_order_mark or ending symbol “^z”. Look on file in some hexeditor and check start and check end of file. I had a similar problems, when I used a files created on other operation system. 1 solved Cannot create plpgsql function using psql … Read more
client.post(/posts/${like.PostId}/likes, { userId: like.userId, PostId:like.PostId }) using this in frontend, i was able to access the req.body in backend, thank you @Anatoly solved How can users like and unlike each others post using sequelize postgres nodejs?