Adding INTERVAL to TIME in SQL

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP

Adding INTERVAL to TIME in SQL



In PostgreSQL (Using pgAdmin 3... That is what my school demands us to use) I'm having an error message when I try and check in a trigger if the NEW event is at the same time as another event going on. 'stime' is in data type TIME and stands for "start time" and 'duration' is in data type INTERVAL.


if (NEW.stime >= schedule.stime AND NEW.stime <= (schedule.stime + schedule.duration))
--Checking if the new event happens while another event is.



The given error is as follows:


ERROR: missing FROM-clause entry for table "schedule"
LINE 5: (NEW.stime >= schedule.stime AND NEW.stime <= (schedule.st...
^
QUERY: SELECT (NEW.sdate IN (SELECT sdate FROM schedule)) AND
--Checking for events in the room at given date.
(NEW.rno IN (SELECT rno FROM schedule WHERE NEW.sdate = schedule.sdate AND NEW.bno = schedule.bno)) AND
--Checking if the new event happens while another event is.
(NEW.stime >= schedule.stime AND NEW.stime <= (schedule.stime + schedule.duration))
CONTEXT: PL/pgSQL function trigf1() line 12 at IF
********** Error **********

ERROR: missing FROM-clause entry for table "schedule"
SQL state: 42P01
Context: PL/pgSQL function trigf1() line 12 at IF





That leaves a lot open. Knowing the error message might help to help you for starters.
– sticky bit
8 hours ago





Right! I'll edit the post to include the error
– Tal Mushkin
8 hours ago




1 Answer
1



I guess schedule is a table (maybe the table the trigger is on?) and the inserted record may not conflict with any of the records of that table.


schedule



If my guess is right you can try to change you line to:


IF EXISTS (SELECT *
FROM schedule
WHERE new.stime >= schedule.stime
AND new.stime <= (schedule.stime + schedule.duration))



If my guess is wrong or my suggestion didn't help, please post the CREATE TABLE statement of the table the trigger is on and that of schedule shouldn't that be the same table. IF schedule is something else than a table, please explain what it is and also post the CREATE statement. Post the full CREATE statement of the trigger function and the CREATE TRIGGER statement as well. And describe what the condition for that IF should be.


CREATE TABLE


schedule


schedule


CREATE


CREATE


CREATE TRIGGER


IF






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

Executable numpy error

Image
Clash Royale CLAN TAG #URR8PPP Executable numpy error I'm trying to create an executable file for my code. I've already tried with cx_Freeze and with pyinstaller. Both gives me the same error, which is: "Missing required dependencies 0.format(missing_dependencies))" PS C:UsersGustavoDesktopbuildexe.win32-3.6> python AgendaOficial.py C:UsersGustavoAppDataLocalProgramsPythonPython36-32python.exe: can't open file 'AgendaOficial.py': [Errno 2] No such file or directory PS C:UsersGustavoDesktopbuildexe.win32-3.6> .AgendaOficial.exe Traceback (most recent call last): File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_Freezeinitscripts__startup__.py", line 14, in run module.run() File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_FreezeinitscriptsConsole.py", line 26, in run exec(code, m. dict ) File "AgendaOficial.py", line 8, in File "C:UsersGustavoAppDataLocal...
Read more

PySpark count values by condition

Image
Clash Royale CLAN TAG #URR8PPP PySpark count values by condition I have a DataFrame, a snippet here: [['u1', 1], ['u2', 0]] basically one string ('f') and either a 1 or a 0 for second element ('is_fav'). What I need to do is grouping on the first field and counting the occurrences of 1s and 0s. I was hoping to do something like num_fav = count((col("is_fav") == 1)).alias("num_fav") num_nonfav = count((col("is_fav") == 0)).alias("num_nonfav") df.groupBy("f").agg(num_fav, num_nonfav) It does not work properly, I get in both cases the same result which amounts to the count for the items in the group, so the filter (whether it is a 1 or a 0) seems to be ignored. Does this depend on how count works? count 1 Answer 1 There is no filter here. Both col("is_fav") == 1 and col("is_fav") == 0) are just boolean expressions and count doesn't really care about their value as long a...
Read more

Mass disable jenkins jobs

Image
Clash Royale CLAN TAG #URR8PPP Mass disable jenkins jobs Is it possible to disable a large number of Jenkins jobs in one go? I have a large number of jenkins job I need to disable. Visiting each job in turn and disbling is tedious. 2 Answers 2 https://wiki.jenkins-ci.org/display/JENKINS/Configuration+Slicing+Plugin That works beautifully install it go to http://your_jenkins.com:8080/slicing/jobdisabledbool/? By using configuration slicing plugin: By using this plugin easy to find out anything has enabled or disable jobs and timer separated jobs Manage Jenkins >Config slicing > select options By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more